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 GetFlowTypeInOut() { int flowID = Convert.ToInt32(Request.Form["FlowID"] ?? "0"); string result = ""; result = WebComm.GetFundFlowTypeList().Where(f => f.ID == flowID).Select(f => f.InOutType).SingleOrDefault(); return(result); }
public string DoBankAccounting() { try { /***校验数据完整性***/ if (Session[SessionList.FamilyManageUser.ToString()] == null) { return(WebComm.ReturnLogOutPage()); } if (Request.Form["FlowTypeID"] == "" || Request.Form["FlowTypeID"] == "-1") { throw new Exception("请选择资金流动类型!"); } User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; //获取记账日期 string applyDate = Request.Form["ApplyDate"]; //获取流动资金类型 FundFlowType ffType = WebComm.GetFundFlowTypeList().Where(f => f.ID == Convert.ToInt32(Request.Form["FlowTypeID"])).Single(); string flowTypeID = ffType.ID.ToString(); //获取流动资金类型名称 string flowTypeName = ffType.Name; //获取类型 string InOutType = ffType.InOutType; //获取费用项目 string feeItemID = Request.Form["search_Fee.FeeItemID"] == "" ? "0" : Request.Form["search_Fee.FeeItemID"]; string feeItemName = Request.Form["search_Fee.FeeItemName"] == "" ? "" : Request.Form["search_Fee.FeeItemName"]; //获取资金 string iMoney = Request.Form["NowMoney"]; string isJieKuan = flowTypeName.Contains("借") == true ? "Y" : "N"; //获取入账银行信息 string inUserBankID = Request.Form["In_bank.UserBankID"] == "" ? "0" : Request.Form["In_bank.UserBankID"]; //获取出账银行信息 string outUserBankID = Request.Form["Out_bank.UserBankID"] == "" ? "0" : Request.Form["Out_bank.UserBankID"]; //获取备注信息 string cAdd = Request.Form["cAdd"]; string sql = "exec proc_AddBankAccouting '" + applyDate + "'," + flowTypeID + ",'" + flowTypeName + "','" + InOutType + "'," + feeItemID + ",'" + feeItemName + "'," + iMoney + "," + loginUser.ID.ToString() + "," + inUserBankID + "," + outUserBankID + ",'" + isJieKuan + "','N','" + cAdd + "','PCWeb',''"; LycSQLHelper.ExecuteCommand(CommandType.Text, sql); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "记账成功!", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "记账失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public ActionResult Edit(int id = 0) { //绑定银行卡类型 ViewBag.CardTypeList = WebComm.GetBankCardType(); UserBank userbank = db.UserBanks.Find(id); if (userbank == null) { return(RedirectToAction("GoTo404Page", "CommView")); } return(View(viewFolder + "Edit.cshtml", userbank)); }
public string DeleteConfirmed(int id) { try { string sql = "exec proc_DeleteAccouting " + id.ToString() + " "; LycSQLHelper.ExecuteCommand(CommandType.Text, sql); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功!", "ApplySubListNav", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败!" + ex.Message, "", "", CallBackType.none, "")); } }
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, "")); } }
//[HttpPost] /// <summary> /// 获取所有费用科目 /// </summary> /// <returns></returns> public JsonResult GetFeeItemList() { LycJsonResult lycResult = new LycJsonResult(); try { lycResult.Data = new JsonResultModel(true, "获取费用科目成功", WebComm.GetFeeItemListByXml()); } catch { lycResult.Data = new JsonResultModel(false, "获取费用科目失败", null); } return(lycResult); }
/// <summary> /// 获取所有资金流动类型 /// </summary> /// <returns></returns> public JsonResult GetFlowTypeList() { LycJsonResult lycResult = new LycJsonResult(); try { lycResult.Data = new JsonResultModel(true, "获取资金类型成功", WebComm.GetFundFlowTypeList()); } catch { lycResult.Data = new JsonResultModel(false, "获取资金类型失败", null); } return(lycResult); }
public string EditUser(User user) { try { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "用户更新失败!" + ex.Message, "", "", CallBackType.none, "")); } return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "用户信息已更新!", "userList", "", CallBackType.closeCurrent, "")); }
public string Edit(SysModel sysmodel) { try { db.Entry(sysmodel).State = EntityState.Modified; db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败!" + ex.Message, "", "", CallBackType.none, "")); } }
/// <summary> /// 绑定银行卡类型 /// </summary> private void BindBankCardType() { Dictionary <string, string> dataSource = new Dictionary <string, string>(); foreach (var item in WebComm.GetBankCardType()) { dataSource.Add(item, item); } Dictionary <string, object> attrCardType = null; List <SelectListItem> itemList = null; WebComm.BindComBox(dataSource, out attrCardType, out itemList); ViewBag.attrCardType = attrCardType; ViewBag.itemList = itemList; }
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 GetFlowTypeList() { int BusinessType = Convert.ToInt32(Request.Form["flowType"]); string result = ""; List <FundFlowType> list = new List <FundFlowType>(); if (BusinessType == 0) { list = WebComm.GetFundFlowTypeList_Cash(); } else if (BusinessType == 1) { list = WebComm.GetFundFlowTypeList_Bank(); } result = JsonConvert.SerializeObject(list); return(result); }
public string DeleteConfirmed() { try { string ids = Request["ids"] ?? ""; int[] idList = WebComm.GetIntArrayByString(ids); foreach (int item in idList) { Bank bank = db.Banks.Find(item); db.Banks.Remove(bank); } db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "bankMainList", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public string Edit(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; db.Entry(userbank).State = EntityState.Modified; db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "userBankList", "", 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 DeleteConfirmed() { try { string ids = Request["ids"] ?? ""; int[] idList = WebComm.GetIntArrayByString(ids); foreach (var item in idList) { User user = db.Users.Find(item); db.Users.Remove(user); } db.SaveChanges(); } 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, "")); } }
public string DeleteConfirmed() { try { string ids = Request["ids"] ?? ""; int[] idList = WebComm.GetIntArrayByString(ids); foreach (int id in idList) { SysModel bank = db.SysModels.Find(id); bank.IsFlag = false; db.Entry(bank).State = EntityState.Modified; } db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public Object Create(int businessTypeID, string inOutType) { if (businessTypeID == 0) { //跳转到现金记账页面 ViewBag.FlowType = WebComm.GetFundFlowTypeList_Cash().Where(c => c.InOutType == "in" || c.InOutType == "out").ToList(); return(PartialView(viewFolder + "CashAccounting.cshtml")); } else if (businessTypeID == 1) { //银行记账 ViewBag.FlowType = WebComm.GetFundFlowTypeList_Bank().Where(c => c.InOutType == "in" || c.InOutType == "out").ToList(); return(PartialView(viewFolder + "BankAccounting.cshtml")); } else { //跳转到转账页面 ViewBag.FlowType = WebComm.GetFundFlowTypeList().Where(c => c.InOutType != "in" && c.InOutType != "out").ToList(); return(PartialView(viewFolder + "ZhuanZhang.cshtml")); } }
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, "")); }
//创建费用项目xml public string CreateFeeXml() { string path = WebComm.FeeItemXmlPath; /* 创建xml文件 * XDocument xdoc = new XDocument( * new XDeclaration("1.0", "utf-8", "yes"), * new XElement("FeeItemList") * ); * xdoc.Save(path); * return "成功"; */ /* 通过List集合遍历添加xml文件*/ XDocument xdoc = XDocument.Load(path); //XElement root = xdoc.Element("FeeItemList"); //root.Add( // WebComm.GetFeeItemList().Select(c => // new XElement("FeeItem", // new XAttribute("FeeItemID", c.FeeItemID), // new XAttribute("FeeItemName", c.FeeItemName), // new XAttribute("FeeItemClassID", c.FeeItemClassID), // new XAttribute("IsLast", c.IsLast) // )) // ); XElement root = xdoc.Element("FeeItems"); root.Add( WebComm.GetFeeItemList().Select(c => new XElement("FeeItem", new XElement("FeeItemID", c.FeeItemID), new XElement("FeeItemName", c.FeeItemName), new XElement("FeeItemClassID", c.FeeItemClassID), new XElement("IsLast", c.IsLast) )) ); xdoc.Save(path); return("成功"); }
public string DeleteConfirmed() { try { string ids = Request["ids"] ?? ""; int[] idList = WebComm.GetIntArrayByString(ids); foreach (int item in idList) { UserBank bank = db.UserBanks.Find(item); if (db.Apply_Sub.Where(u => u.UserBankID == bank.ID).Count() > 0 || db.Apply_Sub_CashChange.Where(u => u.InUserBankID == bank.ID || u.OutUserBankID == bank.ID).Count() > 0) { continue; } db.UserBanks.Remove(bank); } db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "userBankList", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败!" + ex.Message, "", "", CallBackType.none, "")); } }
/// <summary> /// 获取用户开户行列表 /// </summary> /// <param name="currentPage">当前页码</param> /// <param name="uBank">查询实体</param> /// <returns></returns> private List <Apply_Main> GetApply_MainList(int currentPage, Apply_Main AM, string beginDate, string endDate) { var amList = db.Apply_Main.AsQueryable(); User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; //区分用户加载数据,如果不是超级管理员,只能查看自己的数据 if (!UserPower.adminUserCode.Contains(loginUser.cUserCode)) { amList = amList.Where(ub => ub.ApplyUserID == loginUser.ID); } #region 条件筛选 if (AM != null && !string.IsNullOrEmpty(AM.ApplyUserID.ToString()) && AM.ApplyUserID > 0) { amList = amList.Where(ub => ub.ApplyUserID == AM.ApplyUserID); } //如果用户选择了开始时间和结束时间 if (!string.IsNullOrEmpty(beginDate) && !string.IsNullOrEmpty(endDate)) { int[] beginArr = WebComm.GetIntArrayByStringArray(beginDate.Split('-')); int[] endArr = WebComm.GetIntArrayByStringArray(endDate.Split('-')); DateTime bDate, dDate; bDate = Convert.ToDateTime(beginDate); dDate = Convert.ToDateTime(endDate); int beginYear = beginArr[0]; int beginMonth = beginArr[1]; int beginDay = beginArr[2]; int endYear = endArr[0]; int endMonth = endArr[1]; int endDay = endArr[2]; //amList = amList.Where(a => a.iyear >= beginYear && a.imonth >= beginMonth && a.iday >= beginDay) // .Where(a => a.iyear <= endYear && a.imonth <= endMonth && a.iday <= endDay); amList = amList.Where(a => a.ApplyDate >= bDate && a.ApplyDate <= dDate); } //如果只选择了开始时间 else if (!string.IsNullOrEmpty(beginDate) && string.IsNullOrEmpty(endDate)) { DateTime bDate; bDate = Convert.ToDateTime(beginDate); //int[] beginArr = WebComm.GetIntArrayByStringArray(beginDate.Split('-')); //int beginYear = beginArr[0]; //int beginMonth = beginArr[1]; //int beginDay = beginArr[2]; //amList = amList.Where(a => a.iyear >= beginYear && a.imonth >= beginMonth && a.iday >= beginDay); amList = amList.Where(a => a.ApplyDate >= bDate); } #endregion SetPagerOptions(amList.Count(), currentPage); List <Apply_Main> list = amList.OrderBy(b => b.ID).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); //添加合计行 Apply_Main applySum = new Apply_Main(); applySum.Apply_Sub = null; applySum.ApplyDate = new DateTime(); applySum.ApplyInMoney = list.Sum(l => l.ApplyInMoney); applySum.ApplyOutMoney = list.Sum(l => l.ApplyOutMoney); applySum.ApplyUserID = loginUser.ID; applySum.CreateDate = null; applySum.ID = 0; applySum.iday = 0; applySum.imonth = 0; applySum.iNowCashMoney = 0; applySum.iyear = 0; applySum.User = null; list.Insert(0, applySum); return(list); }
public ActionResult Create() { //绑定银行卡类型 ViewBag.CardTypeList = WebComm.GetBankCardType(); return(View(viewFolder + "Create.cshtml")); }
//显示费用项目列表 public ActionResult ShowAccountTypeList() { return(View(viewFolder + "ShowAccountTypeList.cshtml", WebComm.GetAccountListByXml())); }
//内部转账API public string DoZhuanZhang(int userID, string ApplyDate, int FlowTypeID, string feeItemID, string feeItemName, string money, string inUBID, string outUBID, string cAdd, string location) { string result = "{}"; try { //获取记账日期 string applyDate = ApplyDate; //获取流动资金类型 FundFlowType ffType = WebComm.GetFundFlowTypeList().Where(f => f.ID == FlowTypeID).Single(); string flowTypeID = ffType.ID.ToString(); //获取流动资金类型名称 string flowTypeName = ffType.Name; //获取类型 string InOutType = ffType.InOutType; //获取资金 string iMoney = money; //获取入账银行信息 string inUserBankID = inUBID; //获取出账银行信息 string outUserBankID = outUBID; //参数设置 SqlParameter[] sp3 = new SqlParameter[] { new SqlParameter { ParameterName = "@applyDate", Value = applyDate }, new SqlParameter { ParameterName = "@flowTypeID", Value = flowTypeID }, new SqlParameter { ParameterName = "@flowTypeName", Value = flowTypeName }, new SqlParameter { ParameterName = "@InOutType", Value = InOutType }, new SqlParameter { ParameterName = "@iMoney", Value = iMoney }, new SqlParameter { ParameterName = "@UserID", Value = userID }, new SqlParameter { ParameterName = "@InUserBankID", Value = inUserBankID }, new SqlParameter { ParameterName = "@OutUserBankID", Value = outUserBankID }, new SqlParameter { ParameterName = "@CAdd", Value = cAdd }, new SqlParameter { ParameterName = "@CSouce", Value = APPLY_DATASOURCE_IOSAPP }, new SqlParameter { ParameterName = "@CLocation", Value = location ?? "" } }; //执行存储过程 bool success = this.ExecStoredProcedure("proc_CashChange", sp3); if (success) { result = WebComm.ReturnJsonForExterior(true, "转账记账成功!", "{}"); } else { result = WebComm.ReturnJsonForExterior(true, "转账记账失败!", "{}"); } } catch (Exception ex) { result = WebComm.ReturnJsonForExterior(false, "转账记账失败!" + ex.Message, "{}"); } return(result); }
//现金记账API public string DoCashAccounting(int userID, string ApplyDate, int FlowTypeID, string feeItemID, string feeItemName, string money, string cAdd, string location) { string result = "{}"; try { //获取记账日期 string applyDate = ApplyDate; //获取流动资金类型 FundFlowType ffType = WebComm.GetFundFlowTypeList().Where(f => f.ID == FlowTypeID).Single(); string flowTypeID = ffType.ID.ToString(); //获取流动资金类型名称 string flowTypeName = ffType.Name; //获取类型 string InOutType = ffType.InOutType; //获取资金 string iMoney = money; string isJieKuan = flowTypeName.Contains("借") == true ? "Y" : "N"; //参数设置 SqlParameter[] sp1 = new SqlParameter[] { new SqlParameter { ParameterName = "@applyDate", Value = applyDate }, new SqlParameter { ParameterName = "@flowTypeID", Value = flowTypeID }, new SqlParameter { ParameterName = "@flowTypeName", Value = flowTypeName }, new SqlParameter { ParameterName = "@InOutType", Value = InOutType }, new SqlParameter { ParameterName = "@FeeItemID", Value = feeItemID }, new SqlParameter { ParameterName = "@FeeItemName", Value = feeItemName }, new SqlParameter { ParameterName = "@iMoney", Value = iMoney }, new SqlParameter { ParameterName = "@UserID", Value = userID }, new SqlParameter { ParameterName = "@BJieKuan", Value = isJieKuan }, new SqlParameter { ParameterName = "@BHuanKuan", Value = "N" }, new SqlParameter { ParameterName = "@CAdd", Value = cAdd }, new SqlParameter { ParameterName = "@CSouce", Value = APPLY_DATASOURCE_IOSAPP }, new SqlParameter { ParameterName = "@CLocation", Value = location ?? "" } }; //执行存储过程 bool success = this.ExecStoredProcedure("proc_AddCashAccouting", sp1); if (success == true) { result = WebComm.ReturnJsonForExterior(true, "现金记账成功!", "{}"); } else { result = WebComm.ReturnJsonForExterior(false, "现金记账失败!", "{}"); } } catch (Exception ex) { result = WebComm.ReturnJsonForExterior(false, "现金记账失败!" + ex.Message, "{}"); } return(result); }
//显示费用项目列表 public ActionResult ShowFeeItemList() { return(View(viewFolder + "ShowFeeItemList.cshtml", WebComm.GetFeeItemListByXml())); }