日期:2014-05-17 浏览次数:20511 次
private void GetNowPayMoney(List<Sys.Model.StoreInfoModel> li)
{
foreach (Sys.Model.StoreInfoModel item in li)
{
string sql = string.Format(@"select ISNULL(SUM(Payment),0) as NowPayMoney from DataTradeInfo where DATEDIFF(DAY, paytime, getdate()) = 0 AND StoreID={0};", item.StoreID);
//获得当日的数据
DataSet ds = Sys.SQLHelper.SQLExecProc.SqlDataSet(sql.ToString());
rep.DataSource = ds;
rep.DataBind();
}
}