public Dictionary <int, List <int> > upload_base_recorddetails(string newfile, string fileName, string action, JObject json_formdata, string recordinfoid) { Base_Company_Method bcm = new Base_Company_Method(); Switch_helper_Base_blend_web sw = new Switch_helper_Base_blend_web(); DataTable dtExcel = bcm.GetExcelData_Table(Server.MapPath(newfile), 0); List <string> stringList = new List <string>(); //记住发生错误的行数 List <int> errorlines = new List <int>(); //记住插入成功的个数 int count = 0; Sql.busi_RecordInfor bc = new Sql.busi_RecordInfor(); //插入成功的个数(返回放入dictionary) List <int> successinsert = new List <int>(); //返回值 Dictionary <int, List <int> > returndic = new Dictionary <int, List <int> >(); try { 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()); } //项号 if (i == 8) { } RecordDetailEn detail = new RecordDetailEn(stringList, json_formdata); string jsonStr = JsonConvert.SerializeObject(detail); JObject json = (JObject)JsonConvert.DeserializeObject(jsonStr); if (bc.check_repeat_record_details(json, recordinfoid).Rows.Count > 0) { errorlines.Add(i + 2); } else { int f = bc.insert_record_details(recordinfoid, json); if (f > 0) { count = count + 1; } else { errorlines.Add(i + 2); } } stringList.Clear(); } successinsert.Add(count); returndic.Add(1, successinsert); returndic.Add(2, errorlines); } catch (Exception ex) { } return(returndic); }
private void save_recorddetails() { string recordinfoid = Request["recordinfoid"]; string formdata = Request["formdata"]; JObject json = (JObject)JsonConvert.DeserializeObject(formdata); Sql.busi_RecordInfor br = new Sql.busi_RecordInfor(); Base_Codename_Method bm = new Base_Codename_Method(); string response = String.Empty; if (string.IsNullOrEmpty(json.Value <string>("ID"))) { if (json.Value <string>("ENABLED") == "1") { if (br.check_repeat_record_details(json, recordinfoid).Rows.Count > 0) { //当数据有重复时success返回值为4 response = "{\"success\":\"4\"}"; } else { int i = br.insert_record_details(recordinfoid, json); response = "{\"success\":" + (i > 0 ? "true" : "false") + "}"; } } else { int i = br.insert_record_details(recordinfoid, json); response = "{\"success\":" + (i > 0 ? "true" : "false") + "}"; } } else { if (json.Value <string>("ENABLED") == "1") { if (br.check_update_repeat_record_details(json, recordinfoid).Rows.Count > 0) { //当数据有重复时success返回值为4 response = "{\"success\":\"4\"}"; } else { //更新 DataTable dt = br.get_before_change_record_details(json); int i = br.update_record_details(json, recordinfoid); if (i > 0) { string content = bm.getrecordinfodetails(dt, json); br.insert_alert_record_details(json, content); response = "{\"success\":" + (i > 0 ? "true" : "false") + "}"; } } } else { //更新 DataTable dt = br.get_before_change_record_details(json); int i = br.update_record_details(json, recordinfoid); if (i > 0) { string content = bm.getrecordinfodetails(dt, json); br.insert_alert_record_details(json, content); response = "{\"success\":" + (i > 0 ? "true" : "false") + "}"; } } } Response.Write(response); Response.End(); }