public string Create(SysModel sysmodel) { try { sysmodel.IsFlag = true; db.SysModels.Add(sysmodel); db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public string AddUserMenuPower() { try { int UserID = 0; int.TryParse(Request.Form["UserID"], out UserID); string sysModelIDs = Request.Form["checkedModelList"] ?? ""; int[] idList = WebComm.GetIntArrayByString(sysModelIDs); List <UserModelPower> removeList = db.UserModelPowers.Where(m => m.userID == UserID).ToList(); foreach (var item in removeList) { db.UserModelPowers.Remove(item); } foreach (int id in idList) { UserModelPower mpAdd = new UserModelPower() { userID = UserID, modelID = id, modelButtonID = 0 }; db.UserModelPowers.Add(mpAdd); } db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "配置成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "配置失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public string DoTKAction(decimal tkmoney, int id) { string lycResult = ""; try { using (FamilyCaiWuDBEntities db2 = new FamilyCaiWuDBEntities()) { Apply_Sub s = db2.Apply_Sub.Where(c => c.ID == id).SingleOrDefault(); if (s == null) { throw new Exception("此记账信息已不存在,无法执行退款操作!"); } if (s.InOutType != "out" || s.CashOrBank != 1) { throw new Exception("此记账信息不是【银行支出记账】,无法执行退款操作!"); } if (s.UserBankID == null || s.UserBankID.Value == 0) { throw new Exception("此记账信息不是【银行记账】,无法执行退款操作!"); } if (tkmoney == s.iMoney) { throw new Exception("退款金额与原记账金额相同,请直接执行删除操作!"); } if (tkmoney > s.iMoney) { throw new Exception("退款金额大于原记账金额,无法执行退款操作!"); } //1. 修改原记账信息的 备注、记账金额字段 decimal newMoney = s.iMoney - tkmoney; s.CAdd = s.CAdd + ";原记账金额:" + s.iMoney + " 元,现在退款:" + tkmoney + " 元,最终记账金额是:" + newMoney + " 元;"; s.iMoney = newMoney; //2. 修改对应的银行余额信息 UserBank ub = db2.UserBanks.Where(c => c.ID == s.UserBankID.Value).SingleOrDefault(); if (ub == null) { throw new Exception("此记账信息中的银行信息已不存在,无法执行退款操作!"); } ub.NowMoney = ub.NowMoney + tkmoney; //3. 修改记账主信息的支出合计 Apply_Main m = db2.Apply_Main.Where(c => c.ID == s.ApplyMain_BillCode).SingleOrDefault(); if (m != null) { m.ApplyOutMoney = m.ApplyOutMoney - tkmoney; } db2.SaveChanges(); } lycResult = WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "退款成功!", "ApplyInfoListNav", "", CallBackType.none, ""); } catch (Exception ex) { lycResult = WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "退款失败!" + ex.Message, "", "", CallBackType.none, ""); } return(lycResult); }
public string Create(UserAccount ua) { try { User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; ua.UserID = loginUser.ID; ua.ctypeName = WebComm.GetAccountListByXml().Where(c => c.TypeID == int.Parse(Request.Form["ctypeID"])).SingleOrDefault().TypeName; db.UserAccounts.Add(ua); db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "UserAccountList", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public string Create(Bank bank) { try { if (ModelState.IsValid) { db.Banks.Add(bank); db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加银行成功!", "bankMainList", "", CallBackType.none, "")); } } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "验证失败!" + ex.Message, "", "", CallBackType.none, "")); } return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "验证失败!", "", "", CallBackType.none, "")); }
public string Create(UserBank userbank) { try { User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; userbank.BankID = Convert.ToInt32(Request.Form["search_bank.BankID"]); userbank.BankName = Request.Form["search_bank.BankName"]; userbank.UserID = loginUser.ID; userbank.UserName = loginUser.cUserName; userbank.CreateDate = DateTime.Now; db.UserBanks.Add(userbank); db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "userBankList", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败!" + ex.Message, "", "", CallBackType.none, "")); } }
// PUT api/UserBank_WebAPI/5 public HttpResponseMessage PutUserBank(int id, UserBank userbank) { if (ModelState.IsValid && id == userbank.ID) { db.Entry(userbank).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public string CreateUser(User user) { int newUserCode = db.Users.Max(u => u.cUserCode); newUserCode++; user.cUserCode = newUserCode; try { if (ModelState.IsValid) { user.cUserFlag = true; user.dCreateDate = DateTime.Now; db.Users.Add(user); db.SaveChanges(); } } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, ex.Message + ex.InnerException, "", "", CallBackType.none, "")); } return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "保存成功", "userList", "", CallBackType.none, "")); }
public string UpdateAdd(Apply_Sub sub) { try { Apply_Sub updateSub = db.Apply_Sub.Find(sub.ID); updateSub.CAdd = sub.CAdd; db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功!", "ApplyInfoListNav", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public string DeleteConfirmed() { try { string ids = Request["ids"] ?? ""; int[] idList = WebComm.GetIntArrayByString(ids); foreach (int item in idList) { Apply_Main am = db.Apply_Main.Find(item); db.Apply_Main.Remove(am); } db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "UserSRList", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败!" + ex.Message, "", "", CallBackType.none, "")); } }