/// <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);
}
