/// <summary> /// 修改 /// </summary> /// <param name="lifingCost"></param> /// <returns></returns> public String Update(LifingCost lifingCost) { try { int result = new BLLifingCost().Update(lifingCost); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "修改成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "修改失败,失败原因:" + ex.Message })); } }
/// <summary> /// 新增 /// </summary> /// <param name="lifingCost"></param> /// <returns></returns> public String Add(LifingCost lifingCost) { try { lifingCost.Id = Guid.NewGuid().ToString(); int result = new BLLifingCost().Add(lifingCost); if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "新增成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败,失败原因:" + ex.Message })); } }
/// <summary> /// 同时向支出表和收入表中写入数据 /// </summary> /// <param name="outUser">支出用户</param> /// <param name="outPrice">支出金额</param> /// <param name="inUser">收入用户</param> /// <param name="remark">备注</param> /// <returns></returns> public String OutIn(string time, string outUser, string outPrice, string inUser, string remark) { if (outUser == inUser) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "操作失败,支出和收入用户不能一样" })); } //组装数据 LifingCost life = new LifingCost(); life.Id = Guid.NewGuid().ToString(); life.Time = time.GetDateTime(); life.Reason = remark; life.Price = outPrice.GetDouble(); life.CostTypeId = 1000300010; life.FamilyPay = true; life.Notes = remark + " 快速新增"; life.CreateBy = outUser; life.UpdateBy = CurrentUser.Id; life.CreateTime = DateTime.Now; life.UpdateTime = DateTime.Now; Income income = new Income(); income.Id = Guid.NewGuid().ToString(); income.Time = time.GetDateTime(); income.Price = outPrice.GetDouble(); income.Note = remark; income.FamilyIncome = true; income.CreateBy = inUser; income.CreateTime = DateTime.Now; income.UpdateBy = CurrentUser.Id; income.UpdateTime = DateTime.Now; //写入数据库 try { new BLLifingCost().Add(life); new BLIncome().Add(income); return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "操作成功" })); } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "操作失败,失败原因:" + ex.Message })); } }
/// <summary> /// 查询生活费的所有消费名称 /// </summary> /// <param name="key"></param> /// <returns></returns> public List <LifingCost> GetReasons(string key) { List <LifingCost> list = new List <LifingCost>(); string sql = "select Reason from Lifing_Cost group by Reason having Reason like '%@key%'"; SQLiteParameter[] parm = new SQLiteParameter[] { new SQLiteParameter("@key", key) }; DataTable dt = SqlLiteHelper.GetTable(sql, CommandType.Text, parm); for (int i = 0; i < dt.Rows.Count; i++) { LifingCost index = new LifingCost(); index.Reason = dt.Rows[i]["Reason"].GetString(); list.Add(index); } return(list); }
/// <summary> /// 保存 /// </summary> /// <param name="lifingCost"></param> /// <returns></returns> public String Save(LifingCost lifingCost) { //判断Request中是否有接收Files文件 if (Request.Files.Count != 0 && !String.IsNullOrEmpty(lifingCost.ImgUrl)) { //HttpPostedFileBase类,提供对用户上载的单独文件的访问 //获取到用户上传的文件 HttpPostedFileBase file = Request.Files[0]; String fileName = this.Upload(file, "/File/Life/"); lifingCost.ImgUrl = fileName; } //创建人和修改者赋值 Users user = Session["user"] as Users; if (string.IsNullOrEmpty(lifingCost.Id)) { lifingCost.CreateTime = DateTime.Now; lifingCost.CreateBy = user.Id; return(Add(lifingCost)); } else { lifingCost.UpdateTime = DateTime.Now; lifingCost.UpdateBy = user.Id; if (String.IsNullOrEmpty(lifingCost.ImgUrl)) { lifingCost.ImgUrl = new BLLifingCost().Select(lifingCost.Id).ImgUrl; } else { var imgUrl = new BLLifingCost().Select(lifingCost.Id).ImgUrl; if (!String.IsNullOrEmpty(imgUrl)) { System.IO.File.Delete(Server.MapPath(imgUrl)); } } return(Update(lifingCost)); } }
/// <summary> /// 修改生活费操作管理 /// </summary> /// <param name="index">生活费操作管理对象</param> /// <returns></returns> public int Update(LifingCost index) { string sql = "update Lifing_Cost set Id=@Id,TIME=@TIME,Reason=@Reason,Price=@Price,Cost_Type_Id=@Cost_Type_Id,Notes=@Notes,Img_Url=@Img_Url,Create_By=@Create_By,Create_Time=@Create_Time,UpDate_By=@UpDate_By,UpDate_Time=@UpDate_Time,IsMark=@IsMark,FamilyPay=@FamilyPay,CusGroup=@CusGroup where Id=@Id"; SQLiteParameter[] parm = new SQLiteParameter[] { new SQLiteParameter("@Id", index.Id), new SQLiteParameter("@TIME", index.Time), new SQLiteParameter("@Reason", index.Reason), new SQLiteParameter("@Price", index.Price), new SQLiteParameter("@Cost_Type_Id", index.CostTypeId), new SQLiteParameter("@Notes", index.Notes), new SQLiteParameter("@Img_Url", index.ImgUrl), new SQLiteParameter("@Create_By", index.CreateBy), new SQLiteParameter("@Create_Time", index.CreateTime), new SQLiteParameter("@UpDate_By", index.UpdateBy), new SQLiteParameter("@UpDate_Time", index.UpdateTime), new SQLiteParameter("@IsMark", index.IsMark), new SQLiteParameter("@FamilyPay", index.FamilyPay), new SQLiteParameter("@CusGroup", index.CusGroup) }; return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm)); }
/// <summary> /// 增加生活费操作管理 /// </summary> /// <param name="index">生活费操作管理对象</param> /// <returns></returns> public int Add(LifingCost index) { string sql = string.Format(@"insert into Lifing_Cost(Id,TIME,Reason,Price,Cost_Type_Id,Notes,Img_Url,Create_By,Create_Time,UpDate_By,UpDate_Time,IsMark,FamilyPay,CusGroup) values(@Id,@TIME,@Reason,@Price,@Cost_Type_Id,@Notes,@Img_Url,@Create_By,@Create_Time,@UpDate_By,@UpDate_Time,@IsMark,@FamilyPay,@CusGroup)"); SQLiteParameter[] parm = new SQLiteParameter[] { new SQLiteParameter("@Id", index.Id), new SQLiteParameter("@TIME", index.Time), new SQLiteParameter("@Reason", index.Reason), new SQLiteParameter("@Price", index.Price), new SQLiteParameter("@Cost_Type_Id", index.CostTypeId), new SQLiteParameter("@Notes", index.Notes), new SQLiteParameter("@Img_Url", index.ImgUrl), new SQLiteParameter("@Create_By", index.CreateBy), new SQLiteParameter("@Create_Time", index.CreateTime), new SQLiteParameter("@UpDate_By", index.UpdateBy), new SQLiteParameter("@UpDate_Time", index.UpdateTime), new SQLiteParameter("@IsMark", index.IsMark), new SQLiteParameter("@FamilyPay", index.FamilyPay), new SQLiteParameter("@CusGroup", index.CusGroup) }; return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm)); }
/// <summary> /// 修改 /// </summary> /// <returns>影响的行数</returns> public int Update(LifingCost lifingCost) { return(dLLifingCost.Update(lifingCost)); }
/// <summary> /// 新增 /// </summary> /// <returns>影响的行数</returns> public int Add(LifingCost lifingCost) { return(dLLifingCost.Add(lifingCost)); }
/// <summary> /// 将dataTable保存到数据库 /// </summary> /// <param name="dt"></param> /// <returns></returns> public String SaveData(DataTable dt, String userId) { List <LifingCost> list = new List <LifingCost>(); String msg = ""; foreach (DataRow row in dt.Rows) { LifingCost index = new LifingCost(); String type = row["消费类型"].ToString(); //判断类型是否存在 HashTableExp hash = new HashTableExp("Name", type); hash.Add("ParentId", "1000300000"); List <Diction> dictions = new BLDiction().Select(hash); if (dictions.Count <= 0) { msg += "<br/>" + type + "不存在"; continue; } DateTime time; //判断时间是否正确 if (!DateTime.TryParse(row["消费时间"].ToString(), out time)) { msg += "<br/>" + row["消费时间"] + "不是时间类型"; continue; } else { index.Time = time; } double price; //判断金额是否正确 if (!double.TryParse(row["消费金额"].ToString(), out price)) { msg += "<br/>" + row["消费金额"] + "不是数字类型"; continue; } else { index.Price = price; } index.Id = Guid.NewGuid().ToString(); index.Reason = row["消费名称"].ToString(); index.CostTypeId = dictions[0].Id; index.Notes = row["备注"].ToString(); index.CreateBy = userId; index.CreateTime = DateTime.Now; list.Add(index); } int result = dLLifingCost.Add(list); if (result > 0) { return("成功保存" + result + "条数据." + msg); } else { return(msg); } }
/// <summary> /// 新增 /// </summary> /// <param name="bankCard"></param> /// <returns></returns> public String Add(BankCard bankCard) { try { bankCard.Id = Guid.NewGuid().ToString(); int result = new BLBankCard().Add(bankCard); if (bankCard.SaveType == 1000200001 && Request["Income"] == "true") { //纯收入 Income income = new Income() { Id = Guid.NewGuid().ToString(), Time = bankCard.Time, Note = bankCard.Note, Price = bankCard.Price, CreateBy = bankCard.CreateBy, CreateTime = bankCard.CreateTime, IsMark = Request["IsMark"].GetBoolean(), FamilyIncome = Request["FamilyPay"].GetBoolean() }; new BLIncome().Add(income); } if (bankCard.SaveType == 1000200002 && Request["Cost"] == "true") { //消费信息 LifingCost cost = new LifingCost() { Id = Guid.NewGuid().ToString(), Time = bankCard.Time, Reason = bankCard.Note, Price = bankCard.Price, CostTypeId = Request["CostTypeId"].GetDecimal(), Notes = bankCard.Note, CreateBy = bankCard.CreateBy, CreateTime = bankCard.CreateTime, IsMark = Request["IsMark"].GetBoolean(), FamilyPay = Request["FamilyPay"].GetBoolean() }; new BLLifingCost().Add(cost); } if (result > 0) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = true, msg = "新增成功" })); } else { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败" })); } } catch (Exception ex) { return(JsonConvert.JavaScriptSerializer(new ExtResult() { success = false, msg = "新增失败,失败原因:" + ex.Message })); } }