public bool AddOrUpdate2(td_Service_2 entity)
{
var service = new DbHelperEfSql <td_Service_2>();
if (entity.ID < 1)
{
service.Add(entity);
}
return(service.Update(entity, c => c.ID == entity.ID));
}
public JsonResult AddOrUpdate2()
{
var sReturnModel = new ReturnMessageModel();
#region 登录验证
if (!Utits.IsLogin)
{
sReturnModel.ErrorType = 3;
sReturnModel.MessageContent = "登录状态已失效.";
return(Json(sReturnModel));
}
#endregion
int id = RequestParameters.Pint("ID");
string bm = RequestParameters.Pstring("bm");
string ipdz = RequestParameters.Pstring("ipdz");
string zjsj = RequestParameters.Pstring("zjsj");
string xnjm = RequestParameters.Pstring("xnjm");
string xtmc = RequestParameters.Pstring("xtmc");
string bz = RequestParameters.Pstring("bz");
string CPU = RequestParameters.Pstring("CPU");
string nc = RequestParameters.Pstring("nc");
string ypkj = RequestParameters.Pstring("ypkj");
string czxt = RequestParameters.Pstring("czxt");
string glyzh = RequestParameters.Pstring("glyzh");
string glymm = RequestParameters.Pstring("glymm");
string whryzh = RequestParameters.Pstring("whryzh");
string whrymm = RequestParameters.Pstring("whrymm");
string sjzh = RequestParameters.Pstring("sjzh");
string sjmm = RequestParameters.Pstring("sjmm");
//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_2 model;
if (id > 0)
{
model = cBll.GetObjectSer2ById(id);
if (model == null)
{
sReturnModel.ErrorType = 0;
sReturnModel.MessageContent = "操作失败.";
return(Json(sReturnModel));
}
}
model = new td_Service_2();
model.ID = id;
model.Dept_Name = bm;
model.IPdz = ipdz;
model.tjsj = Convert.ToDateTime(zjsj);
model.xnjm = xnjm;
model.xtmc = xtmc;
model.bz = bz;
model.CPU = CPU;
model.nc = nc;
model.ypkj = ypkj;
model.czxt = czxt;
model.glyhm = glyzh;
model.glmm = glymm;
model.whyhm1 = whryzh;
model.whmm1 = whrymm;
model.sjyhm = sjzh;
model.sjmm = sjmm;
if (cBll.AddOrUpdate2(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
}
