protected void Page_Load(object sender, EventArgs e)
{
countPay = bll.GetCountForPay(DateTime.Parse(firstDate.ToString("yyyy-MM-dd")), DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd")));
model = bll2.GetCountForPay(DateTime.Parse(firstDate.ToString("yyyy-MM-dd")), DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd")));
if (model.CID == 0)
{
MODEL.Cost mol = new MODEL.Cost();
mol.CMoney = 1000;
mol.CDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
mol.CTime = DateTime.Now;
mol.CDes = "无";
mol.CIsDel = false;
mol.CBlack = 0;
int newID;
bll2.Add(mol, out newID);
model = bll2.GetModelByID(newID.ToString());
}
//计算每一天的收入
DateTime dt = string.IsNullOrEmpty(Request.QueryString["dt"]) ? firstDate : DateTime.Parse(Request.QueryString["dt"]);
TimeSpan tt = dt.AddMonths(1) - dt;
monthDays = (int)tt.TotalDays; //获取月的天数
DateTime lastDate = dt.AddMonths(1).AddDays(-1); //某个月的最后一天
dcs = bll.GetCountForDay(dt, lastDate);
}
/// <summary>
/// 返回指定时间段的总收入
/// </summary>
/// <param name="dt1"></param>
/// <param name="dt2"></param>
/// <returns></returns>
public MODEL.Cost GetCountForPay(DateTime dt1, DateTime dt2)
{
string sql = "SELECT * from " + strTable + " WHERE cDate BETWEEN '" + dt1.ToString("yyyy-MM-dd") + "' AND '" + dt2.ToString("yyyy-MM-dd") + "'";
System.Data.DataTable dt = SqlHelper.GetTable(sql);
MODEL.Cost model = new MODEL.Cost();
if (dt.Rows.Count > 0)
{
BuildSql.LoadModelData(dt.Rows[0], model, strTable);
}
return(model);
}
/// <summary>
/// 执行更新操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateWithModify(MODEL.Cost model)
{
return(BuildSql.UpdateWithModify(strTable, model));
}
/// <summary>
/// 执行增加操作
/// </summary>
/// <param name="model"></param>
/// <param name="newID"></param>
/// <returns></returns>
public int Add(MODEL.Cost model, out int newID)
{
return(BuildSql.Add(strTable, model, out newID));
}
/// <summary>
/// 执行更新操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateWithModify(MODEL.Cost model)
{
return(dal.UpdateWithModify(model) > 0);
}
/// <summary>
/// 执行增加操作
/// </summary>
/// <param name="model"></param>
/// <param name="newID"></param>
/// <returns></returns>
public bool Add(MODEL.Cost model, out int newID)
{
return(dal.Add(model, out newID) > 0);
}
