public bool AddOrUpdate1(td_Service_1 entity) { if (entity.ID < 1) { dbContext.Add(entity); } return(dbContext.Update(entity, c => c.ID == entity.ID)); }
public JsonResult AddOrUpdate1() { var sReturnModel = new ReturnMessageModel(); #region 登录验证 if (!Utits.IsLogin) { sReturnModel.ErrorType = 3; sReturnModel.MessageContent = "登录状态已失效."; return(Json(sReturnModel)); } #endregion int id = RequestParameters.Pint("ID"); //string DeptId = RequestParameters.Pstring("Dept_Id"); //int jg = RequestParameters.Pint("jg"); //int kt = RequestParameters.Pint("kt"); //int sxt = RequestParameters.Pint("sxt"); //int mhq = RequestParameters.Pint("mhq"); //int UPS = RequestParameters.Pint("UPS"); //int fhm = RequestParameters.Pint("fhm"); //int fhdb = RequestParameters.Pint("fhdb"); //int qtmhzz = RequestParameters.Pint("qtmhzz"); //int fljsb = RequestParameters.Pint("fljsb"); //int fjdsb = RequestParameters.Pint("fjdsb"); //int fdcgr = RequestParameters.Pint("fdcgr"); //int fcsb = RequestParameters.Pint("fcsb"); //int fwq = RequestParameters.Pint("fwq"); string fwqbh = RequestParameters.Pstring("fwqbh"); string xh = RequestParameters.Pstring("xh"); string gmrq = RequestParameters.Pstring("gmrq"); string cpbh = RequestParameters.Pstring("cpbh"); string xlh = RequestParameters.Pstring("xlh"); string gbrq = RequestParameters.Pstring("gbrq"); string wlwz = RequestParameters.Pstring("wlwz"); string jgwz = RequestParameters.Pstring("jgwz"); string gdzcbh = RequestParameters.Pstring("gdzcbh"); string sjkxt = RequestParameters.Pstring("sjkxt"); string IPdz = RequestParameters.Pstring("IPdz"); string ym = RequestParameters.Pstring("ym"); string wg = RequestParameters.Pstring("wg"); string jqm = RequestParameters.Pstring("jqm"); string zyywyy = RequestParameters.Pstring("zyywyy"); string czxt = RequestParameters.Pstring("czxt"); string CPU = RequestParameters.Pstring("CPU"); string nc = RequestParameters.Pstring("nc"); string yp = RequestParameters.Pstring("yp"); string sjywsj = RequestParameters.Pstring("sjywsj"); string sfrb = RequestParameters.Pstring("sfrb"); string zycd = RequestParameters.Pstring("zycd"); string glyhm = RequestParameters.Pstring("glyhm"); string glmm = RequestParameters.Pstring("glmm"); string gsyhm = RequestParameters.Pstring("gsyhm"); string gsmm = RequestParameters.Pstring("gsmm"); string xlhbbg = RequestParameters.Pstring("xlhbbg"); string sfjh = RequestParameters.Pstring("sfjh"); string jhm = RequestParameters.Pstring("jhm"); string jhsl = RequestParameters.Pstring("jhsl"); string sfzbrj = RequestParameters.Pstring("sfzbrj"); //if (fwq < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:服务器数量不能小于1台."; // return Json(sReturnModel); //} var currentUser = Utits.CurrentUser; #region 检查参数(暂不做处理) //if (ECode.Length < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:员工号不能为空."; // return Json(sReturnModel); //} //if (WCode.Length < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:考勤号不能为空."; // return Json(sReturnModel); //} //if (Name.Length < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:姓名不能为空."; // return Json(sReturnModel); //} //if (Dept.Length < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:部门不能为空."; // return Json(sReturnModel); //} //if (Login.Length < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:登录名不能为空."; // return Json(sReturnModel); //} //if (Role == Guid.Empty) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:角色不能为空."; // return Json(sReturnModel); //} //if (id < 1 && Password.Length < 1) //{ // sReturnModel.ErrorType = 0; // sReturnModel.MessageContent = "操作失败:密码不能为空."; // return Json(sReturnModel); //} #endregion var cBll = new BLL_Service(); td_Service_1 model; if (id > 0) { model = cBll.GetObjectSer1ById(id); if (model == null) { sReturnModel.ErrorType = 0; sReturnModel.MessageContent = "操作失败."; return(Json(sReturnModel)); } } model = new td_Service_1(); model.ID = id; model.OperatPid = currentUser.user_Id; model.OperatTime = DateTime.Now; //model.Dept_Id = DeptId; model.fwqbh = fwqbh; model.xh = xh; model.gmrq = Convert.ToDateTime(gmrq); model.cpbb = cpbh; model.xlh = xlh; model.gbrq = Convert.ToDateTime(gbrq); model.wlwz = wlwz; model.jgwz = jgwz; model.gdzcbh = gdzcbh; model.sjkxt = sjkxt; model.IPdz = IPdz; model.ym = ym; model.wg = wg; model.jqm = jqm; model.zyywyy = zyywyy; model.czxt = czxt; model.CPU = CPU; model.nc = nc; model.yp = yp; model.ywsj = sjywsj; model.sfrb = sfrb; model.zycd = zycd; model.glyhm = glyhm; model.glmm = glyhm; model.yhm1 = gsyhm; model.mm1 = gsmm; model.xlhbbgl = xlhbbg; model.sfjh = sfjh; model.jhm = jhm; model.sykyxjhsl = Convert.ToInt32(jhsl); model.sfzb = sfzbrj; model.Dept_Name = ""; if (cBll.AddOrUpdate1(model)) { sReturnModel.ErrorType = 1; sReturnModel.MessageContent = "操作成功."; } else { sReturnModel.ErrorType = 0; sReturnModel.MessageContent = "操作失败."; } return(Json(sReturnModel)); }
/// <summary> /// 服务器 /// </summary> /// <param name="file"></param> /// <returns></returns> public JsonResult ImportServiceExcelFile(HttpPostedFileBase file) { // string filePath = RequestParameters.Pstring("filePath"); if (!Utits.IsLogin) { return(Json(new { jsonrpc = 2.0, error = new { code = 102, message = "登录状态已失效." } })); } string filePathName = string.Empty; string localPath = Server.MapPath(string.Format("/{0}/ServiceData/", Utits.UploadExcelPath)); if (Request.Files.Count == 0) { return(Json(new { jsonrpc = 2.0, error = new { code = 100, message = "文件上传失败." } })); } // string ex = Path.GetExtension(file.FileName); filePathName = DateTime.Now.ToString("yyyyMMddHHssmm") + "_" + file.FileName; if (!System.IO.Directory.Exists(localPath)) { System.IO.Directory.CreateDirectory(localPath); } file.SaveAs(localPath + filePathName); #region 信息 try { var currentUser = Utits.CurrentUser; var OpUserId = currentUser.user_Id; var Opdate = System.DateTime.Now; var mdate = DateTime.Parse("1999/09/09"); var cBll = new BLL_Service(); List <td_Service_1> list = new List <td_Service_1>(); List <td_Service_2> list_2 = new List <td_Service_2>(); using (FileStream fsfile = new FileStream(localPath + filePathName, FileMode.Open, FileAccess.Read)) { XSSFWorkbook workbook = new XSSFWorkbook(fsfile); ISheet sheet_1 = workbook.GetSheetAt(0); //第一个工作表 ISheet sheet_2 = workbook.GetSheetAt(1); ///Excel 第一行是标题,不需要导入数据库的 for (int i = 1; i <= sheet_1.LastRowNum; i++) { IRow row = sheet_1.GetRow(i); td_Service_1 service1 = new td_Service_1(); //第一列不管 if (row.GetCell(1) == null) { service1.fwqbh = ""; } else { service1.fwqbh = row.GetCell(1).StringCellValue; } if (row.GetCell(2) == null) { service1.xh = ""; } else { service1.xh = row.GetCell(2).StringCellValue; } if (row.GetCell(3) == null) { service1.gmrq = mdate; } else { service1.gmrq = row.GetCell(3).DateCellValue; } if (row.GetCell(4) == null) { service1.gbrq = mdate; } else { service1.gbrq = row.GetCell(4).DateCellValue; } if (row.GetCell(5) == null) { service1.cpbb = ""; } else { service1.cpbb = row.GetCell(5).StringCellValue; } if (row.GetCell(6) == null) { service1.xlh = ""; } else { service1.xlh = row.GetCell(6).NumericCellValue.ToString(); } if (row.GetCell(7) == null) { service1.gdzcbh = ""; } else { service1.gdzcbh = row.GetCell(7).StringCellValue; } if (row.GetCell(8) == null) { service1.wlwz = ""; } else { service1.wlwz = row.GetCell(8).StringCellValue; } if (row.GetCell(9) == null) { service1.jgwz = ""; } else { service1.jgwz = row.GetCell(9).StringCellValue; } if (row.GetCell(10) == null) { service1.IPdz = ""; } else { service1.IPdz = row.GetCell(10).StringCellValue; } if (row.GetCell(11) == null) { service1.ym = ""; } else { service1.ym = row.GetCell(11).StringCellValue; } if (row.GetCell(12) == null) { service1.wg = ""; } else { service1.wg = row.GetCell(12).StringCellValue; } if (row.GetCell(13) == null) { service1.jqm = ""; } else { service1.jqm = row.GetCell(13).StringCellValue; } if (row.GetCell(14) == null) { service1.zyywyy = ""; } else { service1.zyywyy = row.GetCell(14).StringCellValue; } if (row.GetCell(15) == null) { service1.czxt = ""; } else { service1.czxt = row.GetCell(15).StringCellValue; } if (row.GetCell(16) == null) { service1.sjkxt = ""; } else { service1.sjkxt = row.GetCell(16).StringCellValue; } if (row.GetCell(17) == null) { service1.CPU = ""; } else { service1.CPU = row.GetCell(17).StringCellValue; } if (row.GetCell(18) == null) { service1.nc = ""; } else { service1.nc = row.GetCell(18).StringCellValue; } if (row.GetCell(19) == null) { service1.yp = ""; } else { service1.yp = row.GetCell(19).StringCellValue; } if (row.GetCell(20) == null) { service1.ywsj = ""; } else { service1.ywsj = row.GetCell(20).StringCellValue; } if (row.GetCell(21) == null) { service1.sfrb = ""; } else { service1.sfrb = row.GetCell(21).StringCellValue; } if (row.GetCell(22) == null) { service1.zycd = ""; } else { service1.zycd = row.GetCell(22).StringCellValue; } if (row.GetCell(23) == null) { service1.glyhm = ""; } else { service1.glyhm = row.GetCell(23).StringCellValue; } if (row.GetCell(24) == null) { service1.glmm = ""; } else { service1.glmm = row.GetCell(24).StringCellValue; } if (row.GetCell(25) == null) { service1.yhm1 = ""; } else { service1.yhm1 = row.GetCell(25).StringCellValue; } if (row.GetCell(26) == null) { service1.mm1 = ""; } else { service1.mm1 = row.GetCell(26).StringCellValue; } if (row.GetCell(27) == null) { service1.xlhbbgl = ""; } else { service1.xlhbbgl = row.GetCell(27).StringCellValue; } if (row.GetCell(28) == null) { service1.sfjh = ""; } else { service1.sfjh = row.GetCell(28).StringCellValue; } if (row.GetCell(29) == null) { service1.jhm = ""; } else { service1.jhm = row.GetCell(29).StringCellValue; } if (row.GetCell(30) == null) { service1.sykyxjhsl = 0; } else { service1.sykyxjhsl = Convert.ToInt32(row.GetCell(30).NumericCellValue); } if (row.GetCell(31) == null) { service1.sfzb = ""; } else { service1.sfzb = row.GetCell(31).StringCellValue; } service1.Dept_Name = ""; service1.OperatTime = Opdate; service1.OperatPid = OpUserId; list.Add(service1); } for (int i = 1; i <= sheet_2.LastRowNum; i++) { IRow row = sheet_2.GetRow(i); td_Service_2 service2 = new td_Service_2(); if (row.GetCell(1) == null) { service2.IPdz = ""; } else { service2.IPdz = row.GetCell(1).StringCellValue; } if (row.GetCell(2) == null || row.GetCell(2).ToString() == "") { service2.tjsj = mdate; } else { service2.tjsj = row.GetCell(2).DateCellValue; } if (row.GetCell(3) == null) { service2.xnjm = ""; } else { service2.xnjm = row.GetCell(3).StringCellValue; } if (row.GetCell(4) == null) { service2.Dept_Name = ""; } else { service2.Dept_Name = row.GetCell(4).StringCellValue; } if (row.GetCell(5) == null) { service2.xtmc = ""; } else { service2.xtmc = row.GetCell(5).StringCellValue; } if (row.GetCell(6) == null) { service2.bz = ""; } else { service2.bz = row.GetCell(6).StringCellValue; } if (row.GetCell(7) == null) { service2.CPU = ""; } else { service2.CPU = row.GetCell(7).StringCellValue; } if (row.GetCell(8) == null) { service2.nc = ""; } else { service2.nc = row.GetCell(8).StringCellValue; } if (row.GetCell(9) == null) { service2.ypkj = ""; } else { service2.ypkj = row.GetCell(9).StringCellValue; } if (row.GetCell(10) == null) { service2.czxt = ""; } else { service2.czxt = row.GetCell(10).StringCellValue; } if (row.GetCell(11) == null) { service2.glyhm = ""; } else { service2.glyhm = row.GetCell(11).StringCellValue; } if (row.GetCell(12) == null) { service2.glmm = ""; } else { service2.glmm = row.GetCell(12).StringCellValue; } if (row.GetCell(13) == null) { service2.whyhm1 = ""; } else { service2.whyhm1 = row.GetCell(13).StringCellValue; } if (row.GetCell(14) == null) { service2.whmm1 = ""; } else { service2.whmm1 = row.GetCell(14).StringCellValue; } if (row.GetCell(15) == null) { service2.sjyhm = ""; } else { service2.sjyhm = row.GetCell(15).StringCellValue; } if (row.GetCell(16) == null) { service2.sjmm = ""; } else { service2.sjmm = row.GetCell(16).StringCellValue; } //Room_sl.OperatTime = Opdate; //Room_sl.OperatPid = OpUserId; list_2.Add(service2); } if (cBll.AddImport_1(list) && cBll.AddImport_2(list_2)) { return(Json(new { jsonrpc = 2.0, message = "导入成功." })); } else { return(Json(new { jsonrpc = 2.0, error = new { code = 100, message = "导入失败." } })); } } } catch (Exception e) { MessageLog.AddLog(string.Format("UpDataProcess(数据导入)异常:{0}", e.Message)); } return(Json(new { jsonrpc = 2.0, error = new { code = 100, message = "系统错误.(请确保数据完整)" } })); #endregion }