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
}
