public ActionResult Get(int id) { if (id <= 0) { return(Json(new ResultModel(string.Format("{0}不存在", this.ModelName)))); } SupBillBLL dal = new SupBillBLL(); ResultModel result = dal.Get(id); if (result.ResultStatus != 0) { return(Json(result)); } object rtnObj = result.ReturnValue; if (rtnObj == null) { return(Json(new ResultModel(string.Format("{0}不存在", this.ModelName)))); } result.ResultStatus = 0; result.Message = string.Format("{0}获取成功", this.ModelName); result.ReturnValue = Newtonsoft.Json.JsonConvert.SerializeObject(rtnObj); return(Json(result)); }
public ActionResult SupBillAdd() { int id = 0; if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out id) || id <= 0) { return(Content(JsUtility.WarmAlert("供应商不存在", redirectUrl))); } SupBillBLL supBillBLL = new SupBillBLL(); ResultModel <SupBill> supBillResult = supBillBLL.LoadSupBills(id); if (supBillResult.ResultStatus != 0) { return(Json(ResultModel.GenericResult <SupBill>(supBillResult))); } List <SupBill> rtnSupBill = supBillResult.ReturnValues; if (rtnSupBill == null) { return(Json(new ResultModel("获取账单列表失败"))); } int supBillCount = rtnSupBill.Count(); if (supBillCount > 0) { return(Content(JsUtility.WarmAlert("供应商本月账单已生成", redirectUrl))); } ResultModel result = supBillBLL.LoadSupEmployeeList(0, 500, null, id); if (result.ResultStatus != 0) { return(Content(JsUtility.WarmAlert("获取错误", redirectUrl))); } System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; if (dt == null) { return(Content(JsUtility.WarmAlert("获取错误", redirectUrl))); } string optJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); ViewData["JsonOptData"] = optJsonStr; return(View()); }
public ActionResult LoadEmployeeSalaryByIdList(int pageIndex, int pageSize, string orderField, string sortOrder, int supBillId) { switch (orderField) { case "EmpSalaryId": orderField = "emps.EmpSalaryId"; break; } string orderStr = string.Format("{0} {1}", orderField, sortOrder); SupBillBLL supbillBLL = new SupBillBLL(); ResultModel result = supbillBLL.LoadEmployeeSalaryByIdList(0, 500, orderStr, supBillId); System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("count", result.AffectCount); dic.Add("data", dt); string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dic, new Newtonsoft.Json.Converters.DataTableConverter()); result.ReturnValue = jsonStr; return(Json(result)); }
public ActionResult Insert(SupBill supBill, SupBillDetail[] details) { supBill.SupBillStatus = (int)StatusEnum.已完成; //string json = Newtonsoft.Json.JsonConvert.SerializeObject(employee); SupBillBLL supBillBLL = new SupBillBLL(); SupBillDetailBLL detailBLL = new SupBillDetailBLL(); //获取企业账单 ResultModel <SupBill> supBillResult = supBillBLL.LoadSupBills(supBill.SupId); if (supBillResult.ResultStatus != 0) { return(Json(ResultModel.GenericResult <SupBill>(supBillResult))); } List <SupBill> rtnSupBill = supBillResult.ReturnValues; if (rtnSupBill == null) { return(Json(new ResultModel("获取账单列表失败"))); } int supBillCount = rtnSupBill.Count(); if (supBillCount > 0) { return(Content(JsUtility.WarmAlert("供应商本月账单已生成", redirectUrl))); } //新增账单 ResultModel result = supBillBLL.Insert(supBill); if (result.ResultStatus != 0) { return(Json(result)); } int supBillId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out supBillId) || supBillId <= 0) { return(Content("账单新增失败")); } //新增制单明细 foreach (SupBillDetail detail in details) { detail.SupBillId = supBillId; detail.DetailStatus = (int)StatusEnum.已完成; result = detailBLL.Insert(detail); if (result.ResultStatus != 0) { return(Json(result)); } } result.Message = "账单新增成功"; result.ReturnValue = ""; result.ResultStatus = 0; return(Json(result)); }