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