![]() |
#2
foshan2008-09-11 14:12
|
注: 2.0 + Access
public static decimal GetLeiJiYiWuFuWuShiJian(string YiGongID,string MyYear)//返回义工年度服务总时数
{
DBAccess db = new DBAccess();
string Min_Date = MyYear + "-1-1";
string Max_Date = MyYear + "-12-31";
string MySql = "select sum(YiWuFuWuShiShu) from [YiWuFuWuJiLu] where [YiGongID]=" + YiGongID
+ " and ([YiWuFuWuShiJian] >='" + DateTime.Parse(Min_Date) + "'"
+ " and [YiWuFuWuShiJian] <='" + DateTime.Parse(Max_Date) + "')";
return (decimal)db.ExecuteScalar(MySql);
}
错误提示如下图:
只有本站会员才能查看附件,请 登录
ACCESS 数据表 YiWuFuWuJiLu 如下图:
只有本站会员才能查看附件,请 登录