public ActionResult ImportContract(string msg = "") { HttpPostedFileBase file = Request.Files["uploadFile"]; if (file == null) { return View("ImportContract"); } string filename = file.FileName; string prefix = System.IO.Path.GetExtension(filename).ToLower().Trim(); if (prefix.Equals(".xls") == false && prefix.Equals(".xlsx") == false) { ModelState.AddModelError("fileerror", "请上传Excel格式的文件。"); return View("ImportContract"); } string folder = Request.MapPath("~/Uploadfiles/"); if (System.IO.Directory.Exists(folder) == false) { System.IO.Directory.CreateDirectory(folder); } if (folder.EndsWith(System.IO.Path.DirectorySeparatorChar.ToString()) == false) { folder += System.IO.Path.DirectorySeparatorChar; } string filepath = folder + DateTime.Now.ToString("yyyyMMddHhmmss")+ prefix ; file.SaveAs( filepath ); List<Models.Beans.Contract> list = Utils.ExcelUtils.ParseExcel(filepath); ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); //int result = dbContext.BatchAddContracts(list , User.Identity.Name); Models.Beans.BatchImportResult result = dbContext.BatchAddContracts(list, User.Identity.Name); string message = string.Empty; message += "共" + result.TotalCount + " 条,新增 " + result.AddCount + "条,更新 " + result.UpdateCount + "条"; if (result.FailureCount != 0) { message += ",失败 " + result.FailureCount + "条。"; } ModelState.AddModelError("summary", message); if (result.ErrorList != null && result.ErrorList .Count > 0 ) { message = ""; foreach (Models.Beans.BatchImportResult.ExcelErrorLine item in result.ErrorList) { string temp = string.Format("行号:{0},信息:{1}" ,item.Line , item.Error ); message += temp; ModelState.AddModelError( item.Line , temp ); } } return View("ImportContract"); }
public JsonResult DeleteContracts(List<int> contractids) { JsonResult json = new JsonResult(); if (contractids == null || contractids.Count < 1) { json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "请选择要删除的记录", null); return json; } ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); bool isok= dbContext.DeleteContracts(contractids); json.Data = new Models.Result((int)Models.ResultCodeEnum.Success, "", ""); return json; }
protected Page<Contract> GetData( Contract query , int pageidx , int pagesize ) { Models.ContractContext dbContext = new Models.ContractContext(); Page<Contract> page = dbContext.QueryByPage(query, pageidx, pagesize); return page; }
public ActionResult EditContract(Contract contract) { if (ModelState.IsValid) { bool isok = CheckContractData(contract); if (isok == false) return View(); ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); contract.modifytime = DateTime.Now; bool isExist = dbContext.ExistContractBySeqAndprojectNum(contract.seq, contract.projectnum, contract.contractid); if (isExist) { ModelState.AddModelError("error", "序号和项目编号已经存在。"); return View(); } bool success = dbContext.EditContract(contract); if (success == true) { return new RedirectResult("~/Contract/ContractList"); } else { ModelState.AddModelError("e3", "保存失败!"); return View(); } } return View (); }
public ActionResult AddContract(Contract model) { try { if (ModelState.IsValid == false) return View(); bool isok = CheckContractData(model); if (isok == false) return View(); ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); bool isExist = dbContext.ExistContractBySeqAndprojectNum( model.seq , model.projectnum ); if (isExist) { ModelState.AddModelError("e1", "序号和项目编号已经存在,操作失败。"); return View(); } model.createtime = DateTime.Now; model.modifytime = model.createtime; model.operatorName = Request.RequestContext.HttpContext.User.Identity.Name; //model.operatorId = bool result = dbContext.AddContract(model); if (result == false) { ModelState.AddModelError("e2", "新增失败。"); return View(); } return new RedirectResult("~/contract/contractlist"); } catch (Exception ex) { ModelState.AddModelError("e3", ex.Message); return View(); } }
public ActionResult EditContract(int contractid) { ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); Contract model = dbContext.GetModel(contractid); return View( model ); }
public List<Contract> GetData(Contract query) { Models.ContractContext dbContext = new Models.ContractContext(); List<Contract> list = dbContext.Query(query); return list; }
public JsonResult DeleteAllContracts() { JsonResult result = null; try { ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); dbContext.DeleteAllContracts(); result = new JsonResult(); result.Data = new Models.Result((int)Models.ResultCodeEnum.Success, "" , null); return result; } catch (Exception ex) { result = new JsonResult(); result.Data = new Models.Result((int)Models.ResultCodeEnum.Error, ex.Message, null); return result; } }
//protected Contract GetNextContract(int contractid, long modifytime) //{ // ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); // dbContext.get //} protected JsonResult AddContract(Contract model) { JsonResult json = null; if (model == null) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "参数错误", ""); return json; } if (string.IsNullOrEmpty(model.contractnum)) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "合同编号不能空", ""); return json; } if (string.IsNullOrEmpty(model.seq)) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "序号不能空",""); return json; } if (string.IsNullOrEmpty(model.projectnum)) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "项目编号不能空", ""); return json; } if (string.IsNullOrEmpty(model.projectname)) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "项目名称不能空", ""); return json; } decimal fbys = 0; if (string.IsNullOrEmpty(model.packageBudget)) { model.packageBudget = "0.00"; } if (decimal.TryParse(model.packageBudget, out fbys) == false) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "分包预算必须是数字", ""); return json; } if (string.IsNullOrEmpty(model.money)) { model.money = "0.00"; } decimal zbje = 0; if (decimal.TryParse(model.money, out zbje) == false) { json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Error, "中标金额必须是数字", ""); return json; } ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); bool isExist = dbContext.ExistContractBySeqAndprojectNum(model.seq, model.projectnum); //dbContext.ExistContract(model.projectnum, model.projectname); if (isExist) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "序号和项目编号已经存在,操作失败。", ""); json = new JsonResult(); json.Data = result; return json; } if (string.IsNullOrEmpty(model.contractrfid) == false) { isExist = dbContext.ExistContract(model.contractrfid); if (isExist) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "标签已经被使用,操作失败。", ""); json = new JsonResult(); json.Data = result; return json; } } model.createtime = DateTime.Now; model.modifytime = model.createtime; model.operatorName = Request.RequestContext.HttpContext.User.Identity.Name; //model.operatorId = bool isok = dbContext.AddContract(model); if ( isok == false ) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "新增操作失败。", ""); json = new JsonResult(); json.Data = result; return json; } json = new JsonResult(); json.Data = new Models.Result((int)Models.ResultCodeEnum.Success, "", ""); return json; }
protected JsonResult EditContract(Contract contract) { decimal fbys = 0; if (string.IsNullOrEmpty(contract.packageBudget)) { contract.packageBudget = "0.00"; } if (decimal.TryParse(contract.packageBudget, out fbys) == false) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "分包预算必须数字", ""); JsonResult json = new JsonResult(); json.Data = result; return json; } if (string.IsNullOrEmpty(contract.money)) { contract.money = "0.00"; } decimal money = 0; if (decimal.TryParse(contract.money, out money) == false) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "中标金额必须数字", ""); JsonResult json = new JsonResult(); json.Data = result; return json; } ContractMvcWeb.Models.ContractContext dbContext = new Models.ContractContext(); bool isExist = dbContext.ExistContractBySeqAndprojectNum(contract.seq, contract.projectnum, contract.contractid); //dbContext.ExistContract(contract.projectnum, contract.projectname , contract.contractid); if (isExist) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "序号和项目编号已经存在,操作失败。", ""); JsonResult json = new JsonResult(); json.Data = result; return json; } if (string.IsNullOrEmpty(contract.contractrfid) == false) { isExist = dbContext.ExistContractNotSelf( contract.contractrfid , contract.contractid ); if (isExist) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "标签已经被使用,操作失败。", ""); JsonResult json = new JsonResult(); json.Data = result; return json; } } contract.modifytime = DateTime.Now; bool success = dbContext.EditContract(contract); if (success == true) { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Success, "", ""); JsonResult json = new JsonResult(); json.Data = result; return json; } else { Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Error, "", ""); JsonResult json = new JsonResult(); json.Data = result; return json; } }