public string PX_PXZT_BMRY_SELECT(string datastring)
{
string token = AppClass.GetSession("token").ToString();
HR_PX_PXZT_BMRY model_HR_PX_PXZT_BMRY = Newtonsoft.Json.JsonConvert.DeserializeObject <HR_PX_PXZT_BMRY>(datastring);
HR_PX_PXZT_BMRY_SELECT rst = hrmodels.PX_PXZT.PXZT_BMRY_SELECT(model_HR_PX_PXZT_BMRY, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
public MES_RETURN_UI PXZT_BMRY_UPDATE(HR_PX_PXZT_BMRY model, string ptoken)
{
MES_RETURN mr = client.PXZT_BMRY_UPDATE(model, ptoken);
MES_RETURN_UI mrui = new MES_RETURN_UI();
mrui.TYPE = mr.TYPE;
mrui.MESSAGE = mr.MESSAGE;
return(mrui);
}
public string EXPOST_PXZT_BMRY(int PXZTID)
{
MES_RETURN_UI rst = new MES_RETURN_UI();
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
try
{
HR_PX_PXZT_BMRY model_HR_PX_PXZT_BMRY = new HR_PX_PXZT_BMRY();
model_HR_PX_PXZT_BMRY.PXZTID = PXZTID;
model_HR_PX_PXZT_BMRY.LB = 2;
HR_PX_PXZT_BMRY_SELECT rst_HR_PX_PXZT_BMRY_SELECT = hrmodels.PX_PXZT.PXZT_BMRY_SELECT(model_HR_PX_PXZT_BMRY, token);
if (rst_HR_PX_PXZT_BMRY_SELECT.MES_RETURN.TYPE == "S")
{
FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/HR/ExportFile/导出模版.xlsx", FileMode.Open, FileAccess.Read);
IWorkbook workbook = new XSSFWorkbook(file);
ISheet sheet = workbook.GetSheetAt(0);
int rowcount = 0;
string tt = "工号,姓名,归属部门,状态";
string[] ttlist = tt.Split(',');
IRow rowtt = sheet.CreateRow(rowcount++);
int cellIndex = 0;
for (int a = 0; a < ttlist.Length; a++)
{
rowtt.CreateCell(cellIndex++).SetCellValue(ttlist[a]);
}
DataTable dtlist = rst_HR_PX_PXZT_BMRY_SELECT.DATALIST;
for (int i = 0; i < dtlist.Rows.Count; i++)
{
cellIndex = 0;
IRow row = sheet.CreateRow(rowcount++);
row.CreateCell(cellIndex++).SetCellValue(dtlist.Rows[i]["GH"].ToString());
row.CreateCell(cellIndex++).SetCellValue(dtlist.Rows[i]["YGNAME"].ToString());
row.CreateCell(cellIndex++).SetCellValue(dtlist.Rows[i]["GSBMNAME"].ToString());
row.CreateCell(cellIndex++).SetCellValue(dtlist.Rows[i]["ZT"].ToString());
}
string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff");
FileStream file1 = new FileStream(string.Format(@"{0}/Areas/HR/ExportFile/{1}.xlsx", Server.MapPath("~"), now), FileMode.Create);
workbook.Write(file1);
file1.Close();
rst.TYPE = "S";
rst.MESSAGE = now;
}
else
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_HR_PX_PXZT_BMRY_SELECT.MES_RETURN));
}
}
catch
{
rst.TYPE = "E";
rst.MESSAGE = "生成文件失败！";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
public HR_PX_PXZT_BMRY_SELECT PXZT_BMRY_SELECT(HR_PX_PXZT_BMRY model, string ptoken)
{
return(client.PXZT_BMRY_SELECT(model, ptoken));
}
public string Data_DaoRu_ZXFJKC(int PXZTID)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
MES_RETURN_UI msg = new MES_RETURN_UI();
try
{
var file = Request.Files[0];
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string gotname = file.FileName;
string savePath = FileSavePath + @"\excel\" + year + @"\" + month + @"\" + gotname;
if (Directory.Exists(FileSavePath + @"\excel\" + year + @"\" + month) == false)
{
Directory.CreateDirectory(FileSavePath + @"\excel\" + year + @"\" + month);
}
file.SaveAs(savePath);
FileInfo fi = new FileInfo(savePath);
if (fi.Exists == true)
{
DataTable data1 = ExcelToDataTable(savePath, 0, true);
System.IO.File.Delete(savePath);
if (data1 != null)
{
if (data1.Columns.Contains("工号") == false || data1.Columns.Contains("姓名") == false)
{
msg.TYPE = "E";
msg.MESSAGE = "请使用新模版！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
try
{
data1.Columns.Add("RYID", typeof(int));
if (data1.Rows.Count > 0)
{
for (int i = 0; i < data1.Rows.Count; i++)
{
if (data1.Rows[i]["工号"].ToString().Trim() != "")
{
if (data1.Rows[i]["工号"].ToString().Trim().Length != 5)
{
msg.TYPE = "E";
msg.MESSAGE = "第" + (i + 2) + "行(工号:" + data1.Rows[i]["工号"].ToString() + ")工号格式不正确！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
if (data1.Rows[i]["姓名"].ToString().Trim() == "")
{
msg.TYPE = "E";
msg.MESSAGE = "第" + (i + 2) + "行(工号:" + data1.Rows[i]["工号"].ToString() + ")姓名格式不正确！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
HR_RY_RYINFO model = new HR_RY_RYINFO();
model.GH = data1.Rows[i]["工号"].ToString().Trim();
model.YGNAME = data1.Rows[i]["姓名"].ToString().Trim();
HR_RY_RYINFO_SELECT staffdata = hrmodels.RY_RYINFO.SELECT(model, token);
if (staffdata.HR_RY_RYINFO_LIST.Length == 0)
{
msg.TYPE = "E";
msg.MESSAGE = "第" + (i + 2) + "行(工号:" + data1.Rows[i]["工号"].ToString() + ")工号不存在，请检查！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
data1.Rows[i]["RYID"] = staffdata.HR_RY_RYINFO_LIST[0].RYID;
}
}
}
}
}
catch (Exception e)
{
msg.TYPE = "E";
msg.MESSAGE = e.ToString();
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
}
for (int i = 0; i < data1.Rows.Count; i++)
{
if (data1.Rows[i]["工号"].ToString().Trim() != "")
{
HR_PX_PXZT_BMRY model = new HR_PX_PXZT_BMRY();
model.RYID = Convert.ToInt32(data1.Rows[i]["RYID"].ToString());
model.PXZTID = PXZTID;
MES_RETURN_UI result = hrmodels.PX_PXZT.PXZT_BMRY_INSERT(model, token);
if (result.TYPE == "E")
{
msg.TYPE = "E";
msg.MESSAGE = "第" + (i + 2) + "行(工号:" + data1.Rows[i]["工号"].ToString() + ")出现问题，" + result.MESSAGE;
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
}
msg.TYPE = "S";
msg.MESSAGE = "新增成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
msg.TYPE = "E";
msg.MESSAGE = "文件读取失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
catch (Exception e)
{
msg.TYPE = "E";
msg.MESSAGE = e.ToString();
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
