public Common.ClientResult.Result SetSuccess(string stopIds, string alltype) { alltype = HttpUtility.HtmlDecode(alltype); IBLL.IEmployeeStopPaymentBLL m_BLL = new BLL.EmployeeStopPaymentBLL(); ValidationErrors validationErrors = new ValidationErrors(); Common.ClientResult.Result result = new Common.ClientResult.Result(); if (!string.IsNullOrEmpty(stopIds)) { string returnValue = string.Empty; SysEntities db = new SysEntities(); List <int> IdList = new List <int>(); string[] strArrayid = stopIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string[] strArrayType = alltype.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); List <int?> InsuranceKindList = new List <int?>();//险种 foreach (string id in strArrayid) { int idd = int.Parse(id); IdList.Add(idd); } foreach (var a in strArrayType) { int InsuranceKindId = (int)(Common.EmployeeAdd_InsuranceKindId)Enum.Parse(typeof(Common.EmployeeAdd_InsuranceKindId), a); InsuranceKindList.Add(InsuranceKindId); } if (SetStopPaymentSuccess(db, IdList, InsuranceKindList)) { //LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + ",员工停缴的信息的Id为" + entity.Id, "员工停缴");//写入日志 result.Code = Common.ClientCode.Succeed; result.Message = "保存成功!"; return(result); //提示创建成功 } else { if (validationErrors != null && validationErrors.Count > 0) { validationErrors.All(a => { returnValue += a.ErrorMessage; return(true); }); } LogClassModels.WriteServiceLog(Suggestion.UpdateFail + ",报减设置成功," + returnValue, "员工停缴");//写入日志 result.Code = Common.ClientCode.Fail; result.Message = Suggestion.UpdateFail + returnValue; return(result); //提示插入失败 } } result.Code = Common.ClientCode.FindNull; result.Message = Suggestion.UpdateFail + ",请核对输入的数据的格式"; //提示输入的数据的格式不对 return(result); }
public ActionResult SetFailByExcel(HttpPostedFileBase files) { Common.ClientResult.Result result = new Common.ClientResult.Result(); result.Code = Common.ClientCode.Fail; result.Message = "导入失败"; #region 导入Excel try { HttpPostedFileBase file = files; string FileName; string savePath = string.Empty; if (file == null || file.ContentLength <= 0) { result.Code = Common.ClientCode.Fail; result.Message = "文件不能为空"; return(Json(new { code = result.Code, msg = result.Message })); } else { string filename = System.IO.Path.GetFileName(file.FileName); int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte string fileEx = System.IO.Path.GetExtension(filename); //获取上传文件的扩展名 string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename); //获取无扩展名的文件名 int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M //string FileType = ".xls";//定义上传文件的类型字符串 string[] FileType = new string[] { ".xls", ".xlsx" }; FileName = NoFileName + DateTime.Now.ToString("yyyyMMddhhmmss") + fileEx; if (!FileType.Contains(fileEx)) { result.Code = Common.ClientCode.Fail; result.Message = "文件类型不对,只能导入Excel文件"; return(Json(new { code = result.Code, msg = result.Message })); } if (filesize >= Maxsize) { result.Code = Common.ClientCode.Fail; result.Message = "上传文件超过4M,不能上传"; //return result; return(Json(new { code = 0, msg = result.Message })); } string path = AppDomain.CurrentDomain.BaseDirectory + "excel/"; savePath = System.IO.Path.Combine(path, FileName); file.SaveAs(savePath); } //string filename = System.IO.Path.GetFileName(file.FileName); string message = string.Empty; DataTable table = Util_XLS.NpoiReadExcle2(savePath, "Sheet1", out message); if (!string.IsNullOrWhiteSpace(message)) { result.Code = Common.ClientCode.Fail; result.Message = message; return(Json(new { code = result.Code, msg = result.Message })); } if (table == null && table.Rows.Count <= 0) { result.Code = Common.ClientCode.Fail; result.Message = "导入Excel中不存在有效信息,请核实!"; return(Json(new { code = result.Code, msg = result.Message })); } IBLL.IEmployeeStopPaymentBLL mbll = new BLL.EmployeeStopPaymentBLL(); string errMsg = mbll.SetStopPaymentFailByExcel(table, LoginInfo.UserID, LoginInfo.UserName); if (errMsg == "") { result.Code = Common.ClientCode.Succeed; result.Message = "导入成功!"; } else { result.Code = Common.ClientCode.Fail; result.Message = errMsg; } return(Json(new { code = result.Code, msg = result.Message })); } catch (Exception ex) { result.Code = Common.ClientCode.Fail; result.Message = ex.Message + "导入失败,请认真检查excel"; return(Json(new { code = result.Code, msg = result.Message })); } #endregion }