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));
}
}
