private void save(string formdata) { JObject json = (JObject)JsonConvert.DeserializeObject(formdata); Base_Company_Method bcm = new Base_Company_Method(); Sql.Base_Company bcsql = new Sql.Base_Company(); //禁用人 string stopman = ""; //返回重复结果 string repeat = ""; //返回前端的值 string response = ""; if (json.Value <string>("ENABLED") == "1") { stopman = ""; } else { FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity; string userName = identity.Name; JObject json_user = Extension.Get_UserInfo(userName); stopman = (string)json_user.GetValue("ID"); } if (String.IsNullOrEmpty(json.Value <string>("ID"))) { //插入数据库 if (json.Value <string>("ENABLED") == "1") { List <int> retunRepeat = bcm.CheckRepeat(json.Value <string>("ID"), json.Value <string>("INCODE"), json.Value <string>("CODE"), json.Value <string>("SOCIALCREDITNO")); repeat = bcm.Check_Repeat(retunRepeat); if (repeat == "") { //insert数据向表base_company当是5时插入成功 bcsql.insert_base_company(json, stopman); repeat = "5"; } } else { bcsql.insert_base_company(json, stopman); repeat = "5"; } } else { if (json.Value <string>("ENABLED") == "1") { //更新数据库 List <int> retunRepeat = bcm.CheckRepeat(json.Value <string>("ID"), json.Value <string>("INCODE"), json.Value <string>("CODE"), json.Value <string>("SOCIALCREDITNO")); repeat = bcm.Check_Repeat(retunRepeat); if (repeat == "") { DataTable dt = bcsql.LoadDataById(json.Value <string>("ID")); int i = bcsql.update_base_company(json, stopman); if (i > 0) { bcsql.insert_base_alterrecord(json, dt); } repeat = "5"; } } else { DataTable dt = bcsql.LoadDataById(json.Value <string>("ID")); int i = bcsql.update_base_company(json, stopman); if (i > 0) { bcsql.insert_base_alterrecord(json, dt); } repeat = "5"; } } response = "{\"success\":\"" + repeat + "\"}"; Response.Write(response); Response.End(); }
public Dictionary <int, List <int> > upload_base_company(string newfile, string fileName, string action, JObject json_formdata) { Base_Company_Method bcm = new Base_Company_Method(); Sql.Base_Company bc = new Sql.Base_Company(); DataTable dtExcel = bcm.GetExcelData_Table(Server.MapPath(newfile), 0); List <string> stringList = new List <string>(); //停用人 string stopman = ""; //存放成功信息 List <int> repeatListsuccess = new List <int>(); //存放失败条数 List <int> repeatListerror = new List <int>(); //记住insert成功的条数 int count = 0; //返回信息 Dictionary <int, List <int> > dcInts = new Dictionary <int, List <int> >(); for (int i = 0; i < dtExcel.Rows.Count; i++) { for (int j = 0; j < dtExcel.Columns.Count; j++) { stringList.Add(dtExcel.Rows[i][j].ToString()); } string DeclNature = ""; //海关企业性质 string InspNature = ""; //商检企业性质 //内部编码 //海关编码 string incode = stringList[0]; string CODE = stringList[1]; //商检编码 //企业名称 string INSPCODE = stringList[2]; string NAME = stringList[3]; //企业英文名称 //货物存放地 string ENGLSHNAME = stringList[4]; string GOODSLOCAL = stringList[5]; //收货人类型 //启用情况 string RECEIVERTYPE = stringList[6]; string ENABLED = stringList[7] == "是"?"1":"0"; //备注 string REMARK = stringList[8]; //维护人 string CREATEMANNAME = json_formdata.Value <string>("CREATEMANNAME"); //启用时间 string STARTDATE = json_formdata.Value <string>("STARTDATE") == "" ? DateTime.MinValue.ToShortDateString() : json_formdata.Value <string>("STARTDATE"); //停用日期 string ENDDATE = json_formdata.Value <string>("ENDDATE") == "" ? DateTime.MaxValue.ToShortDateString() : json_formdata.Value <string>("ENDDATE"); //社会信用代码 string SOCIALCREDITNO = stringList[9]; if (CODE.Length > 6) { DeclNature = CODE.Substring(5, 1); InspNature = CODE.Substring(5, 1); } if (ENABLED == "1") { stopman = ""; } else { FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity; string userName = identity.Name; JObject json_user = Extension.Get_UserInfo(userName); stopman = (string)json_user.GetValue("ID"); } //导入判断条件 List <int> inlist = bcm.CheckRepeat("", incode, CODE, ""); string check_repeat = bcm.Check_Repeat(inlist); if (check_repeat == "") { bc.export_insert_base_company(incode, CODE, INSPCODE, NAME, ENGLSHNAME, GOODSLOCAL, RECEIVERTYPE, ENABLED, REMARK, STARTDATE, ENDDATE, DeclNature, InspNature, stopman, SOCIALCREDITNO); count = count + 1; } else { repeatListerror.Add(i + 2); } //清除 stringList.Clear(); } repeatListsuccess.Add(count); dcInts.Add(1, repeatListsuccess); dcInts.Add(2, repeatListerror); return(dcInts); }