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 ContactAdd()
{
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm"))
{
return(null);
}
M_CRMS_Contact contactMod = new M_CRMS_Contact();
if (Mid > 0)
{
contactMod = contactBll.SelReturnModel(Mid);
}
ViewBag.clientDT = clientBll.Sel();
return(View(contactMod));
}
public ActionResult Contact_Add(M_CRMS_Contact subModel)
{
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm"))
{
return(null);
}
M_CRMS_Contact model = new M_CRMS_Contact();
if (Mid > 0)
{
model = contactBll.SelReturnModel(Mid);
}
model.ClientID = subModel.ClientID;
model.DepName = subModel.DepName;
model.Name = subModel.Name;
model.Sex = subModel.Sex;
model.Post = subModel.Post;
model.Mobile_Office = subModel.Mobile_Office;
model.Mobile_Home = subModel.Mobile_Home;
model.Mobile1 = subModel.Mobile1;
model.Mobile2 = subModel.Mobile2;
model.QQ = subModel.QQ;
model.Wechat = subModel.Wechat;
model.SinaBlog = subModel.SinaBlog;
model.Email = subModel.Email;
model.Address = subModel.Address;
model.Remind = subModel.Remind;
if (model.ID > 0)
{
contactBll.UpdateByID(model);
}
else
{
M_AdminInfo adminMod = B_Admin.GetLogin();
model.CAdminID = adminMod.AdminId;
model.ID = contactBll.Insert(model);
}
return(Content("<script>parent.ContactAddSuccess();</script>"));
}
public bool UpdateByID(M_CRMS_Contact model)
{
return(DBCenter.UpdateByID(model, model.ID));
}
public int Insert(M_CRMS_Contact model)
{
//return Sql.insert(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model));
return(DBCenter.Insert(model));
}
