public bool UpdateDetails(ExpenseCategoryModel smodel) { connection(); SqlCommand cmd = new SqlCommand("UpdateexpenseCategory", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", smodel.id); cmd.Parameters.AddWithValue("@detail", smodel.detail); cmd.Parameters.AddWithValue("@priority", smodel.priority); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i >= 1) { return(true); } else { return(false); } }
/// <summary> /// 根据编号获取数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult GetExpenseCategoryById(string id) { var retModel = new JsonReturnModel(); try { var bootItem = inn.newItem("b_ExpenseCategory", "get"); bootItem.setAttribute("id", id); Item result = bootItem.apply(); if (result.isError()) { retModel.AddError("errorMessage", result.getErrorString()); return(Json(retModel, JsonRequestBehavior.AllowGet)); } ExpenseCategoryModel model = new ExpenseCategoryModel(); model.Id = result.getProperty("id"); model.b_CostName = result.getProperty("b_costname"); model.b_CorresponSubject = result.getProperty("b_corresponsubject"); retModel.data = model; } catch (Exception ex) { retModel.AddError("errorMessage", ex.Message); } return(Json(retModel, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(int id, ExpenseCategoryModel smodel) { try { ExpenseCategoryDBHandle sdb = new ExpenseCategoryDBHandle(); sdb.UpdateDetails(smodel); return(RedirectToAction("Index")); } catch { return(View()); } }
/// <summary> /// 支出类别关系的改变 /// </summary> /// <param name="OrgCode"></param> /// <param name="OrgPhId"></param> /// <param name="mydelete"></param> /// <param name="myinsert"></param> /// <returns></returns> public CommonResult <CorrespondenceSettings2Model> UpdateZCLB(string OrgCode, string OrgPhId, List <CorrespondenceSettings2Model> mydelete, List <ExpenseCategoryModel> myinsert) { CommonResult <CorrespondenceSettings2Model> result = new CommonResult <CorrespondenceSettings2Model>(); if (mydelete != null && mydelete.Count > 0) { for (int i = 0; i < mydelete.Count; i++) { CorrespondenceSettings2Model delete = mydelete[i]; var Deleteid = delete.PhId; try { base.Delete <System.Int64>(Deleteid); } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "设置失败,请重新设置!"; } } } if (myinsert != null && myinsert.Count > 0) { for (int i = 0; i < myinsert.Count; i++) { ExpenseCategoryModel insert = myinsert[i]; var Dwdm = OrgPhId; var Dydm = insert.Dm; var Dylx = "08"; var DefStr1 = OrgCode; try { CorrespondenceSettings2Model correspondence = new CorrespondenceSettings2Model(); correspondence.PersistentState = SUP.Common.Base.PersistentState.Added; correspondence.Dwdm = Dwdm; correspondence.Dydm = Dydm; correspondence.Dylx = Dylx; correspondence.DefStr1 = DefStr1; correspondence.DefStr2 = "0"; SavedResult <Int64> savedResult2 = base.Save <Int64>(correspondence, ""); } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "设置失败,请重新设置!"; } } } return(result); }
private List <ExpenseCategoryModel> MapDataTableToExpenseCategory(DataTable dt) { List <ExpenseCategoryModel> result = new List <ExpenseCategoryModel>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.AsEnumerable()) { var obj = new ExpenseCategoryModel(); obj.CategoryId = Convert.ToInt32(dr["CategoryID"]); obj.CategoryName = dr["Name"].ToString(); result.Add(obj); } } return(result); }
public ActionResult Create(ExpenseCategoryModel smodel) { try { if (ModelState.IsValid) { ExpenseCategoryDBHandle sdb = new ExpenseCategoryDBHandle(); if (sdb.Add(smodel)) { ViewBag.Message = "Details Added Successfully"; ModelState.Clear(); } } return(View()); } catch (Exception e) { e.GetBaseException(); return(View()); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> public JsonResult SaveExpenseCategory(ExpenseCategoryModel model) { var retModel = new JsonReturnModel(); try { //判断费用类别是否已经存在 if (ExpenseCategoryBll.IsExistExpenseCategory(inn, model.b_CostName, model.Id)) { retModel.AddError("errorMessage", @OABordrinCommon.Common.GetLanguageValueByParam("输入的费用类别已经存在!", "ERCommon", "ERItemType", ViewBag.language)); return(Json(retModel, JsonRequestBehavior.AllowGet)); } Item item = null; if (string.IsNullOrEmpty(model.Id)) { item = inn.newItem("b_ExpenseCategory", "add"); } else { item = inn.newItem("b_ExpenseCategory", "edit"); item.setAttribute("id", model.Id); } item.setProperty("b_costname", model.b_CostName); item.setProperty("b_corresponsubject", model.b_CorresponSubject); var result = item.apply(); if (result.isError()) { retModel.AddError("errorMessage", result.getErrorString()); } } catch (Exception ex) { retModel.AddError("errorMessage", ex.Message); } return(Json(retModel, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 保存数据 /// </summary> /// <returns>返回Json串</returns> public string Save() { /*string mstformData = System.Web.HttpContext.Current.Request.Form["mstformData"]; * string otype = System.Web.HttpContext.Current.Request.Form["otype"]; * var mstforminfo = DataConverterHelper.JsonToEntity<ExpenseCategoryModel>(mstformData); * * List<ExpenseCategoryModel> expenseCategories = mstforminfo.AllRow; * var checkresult = ExpenseCategoryService.ExecuteDataCheck(ref expenseCategories,otype); * if (checkresult != null && checkresult.Status == ResponseStatus.Error) * { * return DataConverterHelper.SerializeObject(checkresult); * } * * var savedresult = ExpenseCategoryService.Save<Int64>(mstforminfo.AllRow);*/ string Data2 = System.Web.HttpContext.Current.Request.Params["Data2"]; string edittype = System.Web.HttpContext.Current.Request.Params["edittype"]; ExpenseCategoryModel expenseCategory = JsonConvert.DeserializeObject <ExpenseCategoryModel>(Data2); var savedresult = ExpenseCategoryService.Save2(expenseCategory, edittype); return(DataConverterHelper.SerializeObject(savedresult)); }
public ExpenseCategoryModel Update(int businessId, ExpenseCategoryModel model) { return(ApiRequest <ExpenseCategoryModel, ExpenseCategoryModel>("/business/" + businessId + "/employeeexpensecategory/" + model.Id, model, Method.PUT)); }
public ExpenseCategoryModel Create(int businessId, ExpenseCategoryModel model) { return(ApiRequest <ExpenseCategoryModel, ExpenseCategoryModel>("/business/" + businessId + "/employeeexpensecategory", model, Method.POST)); }
public static ExpenseCategory ToEntity(this ExpenseCategoryModel model, ExpenseCategory destination) { return(model.MapTo(destination)); }
public static ExpenseCategory ToEntity(this ExpenseCategoryModel model) { return(model.MapTo <ExpenseCategoryModel, ExpenseCategory>()); }