public IActionResult ContactImport_Upload() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm")) { } var file = Request.Form.Files["file_up"]; if (file == null) { return(WriteErr("未指定文件")); } if (file.Length < 100) { return(WriteErr("文件为空")); } string ext = Path.GetExtension(file.FileName).ToLower(); if (ext != ".xlsx") { return(WriteErr("只允许上传xlsx文件")); } DataTable excelDT = Import_Logical.Excel_ToDT(XMLPath_Contact, file.OpenReadStream()); //将数据直接写入数据库,或将其转换为模型再写入 foreach (DataRow dr in excelDT.Rows) { M_CRMS_Contact model = new M_CRMS_Contact().GetModelFromReader(dr); contactBll.Insert(model); } return(WriteOK("联系人导入成功", "ClientImport")); }
public IActionResult Import_Submit() { var file = Request.Form.Files["file_up"]; if (file == null) { return(WriteErr("未指定文件")); } if (file.Length < 100) { return(WriteErr("文件为空")); } string ext = Path.GetExtension(file.FileName).ToLower(); if (ext != ".xlsx") { return(WriteErr("只允许上传xlsx文件")); } //------------------------- DataTable excelDT = Import_Logical.Excel_ToDT(XMLPath, file.OpenReadStream()); B_CodeModel codeBll = new B_CodeModel(excelDT.TableName); DataTable modelDT = codeBll.SelStruct(); //将数据直接写入数据库,或将其转换为模型再写入 foreach (DataRow dr in excelDT.Rows) { //将第一列作为主键忽略掉 codeBll.Insert(dr, modelDT.Columns[0].ColumnName); } return(WriteOK("数据导入完成")); }
public void Import_Client() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm")) { return; } var file = Request.Files["file_up"]; if (file == null) { function.WriteErrMsg("未指定文件"); return; } if (file.ContentLength < 100) { function.WriteErrMsg("文件为空"); return; } string ext = Path.GetExtension(file.FileName).ToLower(); if (ext != ".xlsx") { function.WriteErrMsg("只允许上传xlsx文件"); return; } DataTable excelDT = Import_Logical.Excel_ToDT(XMLPath_Client, file.InputStream); DataTable typeDT = attrBll.Sel("ctype"); //将数据直接写入数据库,或将其转换为模型再写入 foreach (DataRow dr in excelDT.Rows) { M_CRMS_Client model = new M_CRMS_Client().GetModelFromReader(dr); //clientType统一让用户填中文,转化为中文 //model.ClientType = StrHelper.IdsFormat(model.ClientType); #region ClientType if (!string.IsNullOrEmpty(model.ClientType)) { model.ClientType = model.ClientType.Replace(" ", ""); string[] ctypeArr = model.ClientType.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); foreach (string ctype in ctypeArr) { typeDT.DefaultView.RowFilter = "Value='" + ctype + "'"; if (typeDT.DefaultView.ToTable().Rows.Count < 1) { //新增ClientType M_CRMS_Attr attrMod = new M_CRMS_Attr(); attrMod.ZType = "ctype"; attrMod.Value = ctype; attrBll.Insert(attrMod); typeDT = attrBll.Sel("ctype"); } } } #endregion clientBll.Insert(model); } function.WriteSuccessMsg("客户信息导入成功", "ClientImport"); }
public void ContactImport_Down() { Import_Logical.Excel_CreateByXML(XMLPath_Contact, "ContactTlp"); }
public void Import_DownTlp() { //string csv = Import_Logical.CreateCSVByXML(XMLPath_Client); //SafeC.DownStr(csv, "客户模板.xls", Encoding.Default); Import_Logical.Excel_CreateByXML(XMLPath_Client, "ClientTlp"); }
public IActionResult Import_DownTlp() { Import_Logical.Excel_CreateByXML(XMLPath, "Template"); return(View()); }