public string SELECT_PXZT_RY(string datastring)
{
string token = AppClass.GetSession("token").ToString();
HR_PX_PXZT model_HR_PX_PXZT = Newtonsoft.Json.JsonConvert.DeserializeObject <HR_PX_PXZT>(datastring);
HR_PX_PXZT_SELECT rst = hrmodels.PX_PXZT.SELECT_PXZT_RY(model_HR_PX_PXZT, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
public MES_RETURN_UI INSERT_PXZTMX(HR_PX_PXZT model, string ptoken)
{
MES_RETURN mr = client.INSERT_PXZTMX(model, ptoken);
MES_RETURN_UI mrui = new MES_RETURN_UI();
mrui.TYPE = mr.TYPE;
mrui.MESSAGE = mr.MESSAGE;
return(mrui);
}
public MES_RETURN_UI UPDATE_PXZT(HR_PX_PXZT model, string ptoken)
{
MES_RETURN mr = client.UPDATE_PXZT(model, ptoken);
MES_RETURN_UI mrui = new MES_RETURN_UI();
mrui.TYPE = mr.TYPE;
mrui.MESSAGE = mr.MESSAGE;
return(mrui);
}
public string UPDATE_PXZT(string datastring)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
HR_PX_PXZT model_HR_PX_PXZT = Newtonsoft.Json.JsonConvert.DeserializeObject <HR_PX_PXZT>(datastring);
model_HR_PX_PXZT.XGR = STAFFID;
MES_RETURN_UI rst = hrmodels.PX_PXZT.UPDATE_PXZT(model_HR_PX_PXZT, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
public string Data_Insert_HRfile(int PXZTID) //上传文件
{
var file = Request.Files[0];
string gotname = file.FileName;
string[] name = gotname.Split('.');
string fileName = name[0];
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string today = DateTime.Now.Day.ToString();
string FileFolder = year + "-" + month + "-" + today;
int count = name.Length - 1;
string FFNAME = HRFile + @"\upload\file" + @"\FILE\" + FileFolder;
string Path_Data = HRFile + @"\upload\file" + @"\FILE\" + FileFolder + @"\" + fileName + "." + name[count];
string Path = HRFile2 + @"\\upload\\file" + @"\\FILE\\" + FileFolder + @"\\" + fileName + "." + name[count];
string netpath = System.Configuration.ConfigurationManager.AppSettings["HRNETPATH"] + @"file\/" + @"FILE\/" + FileFolder + @"\/" + fileName + "." + name[count];
if (!Directory.Exists(FFNAME))
{
Directory.CreateDirectory(FFNAME);
file.SaveAs(Path);
}
else
{
file.SaveAs(Path);
}
FileInfo fi = new FileInfo(Path);
if (fi.Exists == true)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
HR_PX_PXZT model_HR_PX_PXZT = new HR_PX_PXZT();
model_HR_PX_PXZT.PXZTID = PXZTID;
model_HR_PX_PXZT.FJURL = Path;
model_HR_PX_PXZT.FJREMARK = fileName;
model_HR_PX_PXZT.CJR = STAFFID;
hrmodels.PX_PXZT.INSERT_PXZT_FJ(model_HR_PX_PXZT, token);
string json = "{\"code\":0,\"res\":\"" + netpath + "\",\"locapath\":\"" + Path + "\"}";
return(json);
}
else
{
return("");
}
}
public HR_PX_PXZT_SELECT SELECT_PXZT_RY(HR_PX_PXZT model, string ptoken)
{
return(client.SELECT_PXZT_RY(model, ptoken));
}
public string Data_DaoRu_PXRY(int PXZTID)
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = AppClass.GetSession("token").ToString();
DaoRuMsg msg = new DaoRuMsg();
try
{
var file = Request.Files[0];
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string gotname = file.FileName;
string savePath = HRFile + @"\upload\excel\" + year + @"\" + month + @"\" + gotname;
if (Directory.Exists(HRFile + @"\upload\excel\" + year + @"\" + month) == false)
{
Directory.CreateDirectory(HRFile + @"\upload\excel\" + year + @"\" + month);
}
file.SaveAs(savePath);
FileInfo fi = new FileInfo(savePath);
if (fi.Exists == true)
{
string[] sheet = { "培训人员导入" };
//开始做数据校验
DataTable data1 = ExcelToDataTable(savePath, 0, true);
#region
if (data1 != null)
{
if (data1.Columns.Contains("工号") == false)
{
msg.Msg = "请使用新增模版！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
try
{
//做数据验证
if (data1.Rows.Count > 0)
{
for (int i = 0; i < data1.Rows.Count; i++)
{
if (data1.Rows[i]["工号"].ToString() != "")
{
if (data1.Rows[i]["工号"].ToString().Length != 5)
{
msg.Msg = "工会导入第" + (i + 2) + "行工号格式不正确！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
HR_RY_RYINFO model = new HR_RY_RYINFO();
model.GH = data1.Rows[i]["工号"].ToString();
HR_RY_RYINFO_SELECT staffdata = hrmodels.RY_RYINFO.SELECT(model, token);
if (staffdata.HR_RY_RYINFO_LIST.Length == 0)
{
msg.Msg = "工会导入第" + (i + 2) + "行工号不存在！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
}
}
}
catch (Exception e)
{
msg.Msg = e.ToString();
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
}
#endregion
//能到这儿就说明数据是没问题的了...大概，然后才进行数据库写入
#region
for (int i = 0; i < data1.Rows.Count; i++)
{
#region
if (data1.Rows[i]["工号"].ToString() != "")
{
HR_RY_RYINFO insert_model = new HR_RY_RYINFO();
insert_model.GH = data1.Rows[i]["工号"].ToString();
HR_RY_RYINFO_SELECT staffdata = hrmodels.RY_RYINFO.SELECT(insert_model, token);
HR_PX_PXZT model = new HR_PX_PXZT();
model.RYID = staffdata.HR_RY_RYINFO_LIST[0].RYID;
model.PXZTID = PXZTID;
model.CJR = STAFFID;
MES_RETURN_UI result = hrmodels.PX_PXZT.INSERT_PXZTMX(model, token);
if (result.TYPE == "E")
{
msg.Msg = "培训人员导入的第" + (i + 2) + "行出现问题，请记录当前报错信息并联系管理员";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
#endregion
}
#endregion
msg.Msg = "新增成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
else
{
msg.Msg = "文件读取失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
catch (Exception e)
{
msg.Msg = e.ToString();
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
