public string Data_Update_Invoice(string data) { token = appClass.CRM_Gettoken(); CRM_MSG_INVOICE model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_MSG_INVOICE>(data); model.XGR = appClass.CRM_GetStaffid(); int i = crmModels.MSG_INVOICE.Update(model, token); webmsg.KEY = i; if (i > 0) { webmsg.MSG = "修改成功!"; } else { webmsg.MSG = "修改失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public string Data_Insert_Invoice(string data) { token = appClass.CRM_Gettoken(); CRM_MSG_INVOICE model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_MSG_INVOICE>(data); model.CJR = appClass.CRM_GetStaffid(); model.ISACTIVE = 1; int i = crmModels.MSG_INVOICE.Create(model, token); webmsg.KEY = i; if (i > 0) { webmsg.MSG = "新增成功"; } else { webmsg.MSG = "新增失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public int Update(CRM_MSG_INVOICE model, string ptoken) { return(client.Update(model, ptoken)); }
public string Data_DaoRu_Invoice() { token = appClass.CRM_Gettoken(); DaoRuMsg msg = new DaoRuMsg(); try { var file = Request.Files[0]; //string date = DateTime.Now.ToString("yyyyMMddHHmmss"); //string fileName = date + "_" + KHID; string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string gotname = file.FileName; //string[] name = gotname.Split('.'); //int count = name.Length - 1; //string savePath = @"E:\CRM\Areas\CRM\upload\" + year + @"\" + month + @"\" + fileName + "." + name[count]; string savePath = FileSavePath + @"\excel\" + year + @"\" + month + @"\" + gotname; if (Directory.Exists(FileSavePath + @"\excel\" + year + @"\" + month) == false) { Directory.CreateDirectory(FileSavePath + @"\excel\" + year + @"\" + month); } file.SaveAs(savePath); FileInfo fi = new FileInfo(savePath); if (fi.Exists == true) { string[] sheet = { "发票" }; //开始做数据校验 DataTable data1 = ExcelToDataTable(savePath, sheet[0], true); //发票 #region if (data1 != null) { if (data1.Columns.Contains("发票号码") == false || data1.Columns.Contains("发票数量") == false || 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++) { bool sap404 = false; if (data1.Rows[i]["客户SAP编号"].ToString() != "" && crmModels.KH_KH.ReadBySAPSN(data1.Rows[i]["客户SAP编号"].ToString(), token).KHID == 0) { sap404 = true; } if (sap404) { msg.Msg = "发票第" + (i + 2) + "行客户SAP编号不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (Regex.IsMatch(data1.Rows[i]["发票数量"].ToString(), @"^\d+$") == false) { msg.Msg = "发票第" + (i + 2) + "行发票数量必须为全数字!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (data1.Rows[i]["寄送日期"].ToString() != "") { try { DateTime myDT = Convert.ToDateTime(data1.Rows[i]["寄送日期"].ToString()); } catch { 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 CRM_KH_KH KHmodel = crmModels.KH_KH.ReadBySAPSN(data1.Rows[i]["客户SAP编号"].ToString(), token); CRM_MSG_INVOICE model = new CRM_MSG_INVOICE(); model.KHID = KHmodel.KHID; model.FPHM = data1.Rows[i]["发票号码"].ToString().Trim(); model.FPSL = Convert.ToInt32(data1.Rows[i]["发票数量"].ToString().Trim()); model.KDDH = data1.Rows[i]["快递单号"].ToString().Trim(); model.JSRQ = Convert.ToDateTime(data1.Rows[i]["寄送日期"].ToString()).ToString("yyyy-MM-dd"); model.BEIZ = data1.Rows[i]["备注"].ToString().Trim(); model.ISACTIVE = 1; model.CJR = appClass.CRM_GetStaffid(); int id = crmModels.MSG_INVOICE.Create(model, token); if (id <= 0) { 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)); } }