/// <summary> /// 得到一个对象实体 /// </summary> public static List <SMS.Model.ChargeStatics> GetChargeStatics(DateTime StartDate, DateTime EndDate) { List <SMS.Model.ChargeStatics> list = new List <SMS.Model.ChargeStatics>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select PrepaidAccount, sum(Money) Money,sum(SMSCount) SMSCount from plat_ChargeRecord "); strSql.Append(" where ChargeFlag=0 and PrepaidTime between @StartDate and @EndDate group by PrepaidAccount"); MySqlParameter[] parameters = { new MySqlParameter("@StartDate", MySqlDbType.DateTime) { Value = StartDate }, new MySqlParameter("@EndDate", MySqlDbType.DateTime) { Value = EndDate } }; DataSet ds = DBUtility.MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables.Count == 0) { return(list); } if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { SMS.Model.ChargeStatics mc = new SMS.Model.ChargeStatics(); if (row["PrepaidAccount"] != null) { mc.Enterprese = row["PrepaidAccount"].ToString(); } if (row["Money"] != null && row["Money"].ToString() != "") { mc.TotalMoney = decimal.Parse(row["Money"].ToString()); } if (row["SMSCount"] != null && row["SMSCount"].ToString() != "") { mc.SMSCount = long.Parse(row["SMSCount"].ToString()); } list.Add(mc); } } return(list); }
/// <summary> /// 得到一个对象实体 /// </summary> public static List <SMS.Model.ChargeStatics> GetChargeStatics() { List <SMS.Model.ChargeStatics> list = new List <SMS.Model.ChargeStatics>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select PrepaidAccount, sum(Money) Money,sum(SMSCount) SMSCount from plat_ChargeRecord "); strSql.Append(" where ChargeFlag=0 group by PrepaidAccount"); DataSet ds = DBUtility.MySqlHelper.Query(strSql.ToString()); if (ds.Tables.Count == 0) { return(list); } if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { SMS.Model.ChargeStatics mc = new SMS.Model.ChargeStatics(); if (row["PrepaidAccount"] != null) { mc.Enterprese = row["PrepaidAccount"].ToString(); } if (row["Money"] != null && row["Money"].ToString() != "") { mc.TotalMoney = decimal.Parse(row["Money"].ToString()); } if (row["SMSCount"] != null && row["SMSCount"].ToString() != "") { mc.SMSCount = long.Parse(row["SMSCount"].ToString()); } list.Add(mc); } } return(list); }