/// <summary> /// 总金额 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <param name="expendType">支付类型</param> /// <param name="itemName">名称</param> /// <param name="amount_1">金额_1</param> /// <param name="amount_2">金额_2</param> /// <returns>总金额</returns> public string Get_Total_Amount(DateTime startDate, DateTime endDate, string expendType, string itemName, string amount_1, string amount_2) { if (expend == null) { expend = new Expend_DAL(); } return(expend.Get_Total_Amount(startDate, endDate, expendType, itemName, amount_1, amount_2)); }
/// <summary> /// 根据主键查询数据 /// </summary> /// <param name="id">主键</param> /// <returns>返回数据集</returns> public Expend Get_Entity(int id) { if (expend == null) { expend = new Expend_DAL(); } return(expend.Get_Data(id).GetEntity <Expend>()); }
/// <summary> /// 获取天的数据 /// </summary> /// <param name="yaers">年</param> /// <param name="month">月</param> /// <param name="expendtype">类型</param> /// <returns></returns> public DataTable Get_Day_Data(int yaers, int month, string expendtype) { if (expend == null) { expend = new Expend_DAL(); } return(expend.Get_Day_Data(yaers, month, expendtype).Tables[0]); }
/// <summary> /// 获取年的数据 /// </summary> /// <param name="startDate">开始时间</param> /// <param name="endDate">结束时间</param> /// <param name="expendtype">类型</param> /// <returns></returns> public DataTable Get_Yaer_Data(int startDate, int endDate, string Expendtype) { if (expend == null) { expend = new Expend_DAL(); } return(expend.Get_Yaer_Data(startDate, endDate, Expendtype).Tables[0]); }
/// <summary> /// 更新 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> public int Update(Expend entity) { if (expend == null) { expend = new Expend_DAL(); } int value = expend.Update(entity); ContentsArray[1] = Combination.Log_Contents_Json("更新后信息", "Expend", Json.Serialization(entity)); Update_Log(value, Combination.Get_PartialContents_ResultsDescribed(entity.ItemName, "支出账目")); return(value); }
/// <summary> /// 删除 /// </summary> /// <param name="id">主键</param> /// <returns></returns> public int Delete(int id) { if (expend == null) { expend = new Expend_DAL(); } int value = expend.Delete(id); if (Combination == null) { Combination = new ContentsCombination(); } Contents = Combination.Log_Contents_PrimaryKey("T_SYS_USER", id.ToString()); Delete_Log(value, "删除“" + id + "”支出账目主键"); return(value); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> public int Add(Expend entity) { if (expend == null) { expend = new Expend_DAL(); } int value = expend.Add(entity); if (Combination == null) { Combination = new ContentsCombination(); } Contents = Combination.Log_Contents_Json("Expend", Json.Serialization(entity)); Add_Log(value, "支出账目“" + entity.ItemName + "”"); return(value); }