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
}
