public IActionResult ClientView()
{
if (Mid < 1)
{
return(WriteErr("未指定客户信息")); return(null);
}
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm"))
{
return(null);
}
M_CRMS_Client clientMod = new M_CRMS_Client();
M_ModelInfo modMod = modBll.SelReturnModel(48);
ViewBag.fieldDT = new B_ModelField().SelByModelID(modMod.ModelID, false, false);
clientMod = clientBll.SelReturnModel(Mid);
if (!string.IsNullOrEmpty(modMod.TableName) && clientMod.ItemID > 0)
{
ViewBag.valueDT = DBCenter.Sel(modMod.TableName, "ID=" + clientMod.ItemID);
}
ViewBag.conSetting = contactBll.SelPage(CPage, PSize, new F_CRMS_Contact()
{
ClientID = clientMod.ID
});
if (!string.IsNullOrEmpty(clientMod.LinkIds))
{
SafeSC.CheckIDSEx(clientMod.LinkIds);
ViewBag.linkDT = DBCenter.SelWithField(clientMod.TbName, "id,ClientName AS name,phone", "ID IN (" + clientMod.LinkIds + ")");
}
return(View(clientMod));
}
public IActionResult Client_Add(M_CRMS_Client model)
{
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm"))
{
}
model.ClientType = StrHelper.IdsFormat(Request.Form["ClientType"]);
model.ID = Mid;
M_ModelInfo modMod = modBll.SelReturnModel(48);
DataTable fieldDT = fieldBll.SelByModelID(modMod.ModelID, false);
DataTable table = Call.GetDTFromMVC(fieldDT, Request);
model.ModelID = modMod.ModelID;
model.ModelTable = modMod.TableName;
model.CAdminID = adminMod.AdminId;
model.LinkIds = Request.Form["LinkIds"];
if (model.ID < 1)
{
model.ID = clientBll.Insert(model, table);
}
else
{
M_CRMS_Client clientMod = clientBll.SelReturnModel(Mid);
model.ItemID = clientMod.ItemID;
model.CDate = clientMod.CDate;
model.CUserID = clientMod.CUserID;
model.Flow = clientMod.Flow;
clientBll.UpdateByID(model, table);
}
return(WriteOK("操作成功", "ClientList"));
}
public IActionResult Client_Add(M_CRMS_Client model)
{
model.ClientType = StrHelper.IdsFormat(RequestEx["ClientType"]);
model.ID = Mid;
M_ModelInfo modMod = modBll.SelReturnModel(48);
//DataTable fieldDT = fieldBll.SelByModelID(modMod.ModelID, false);
//DataTable table = new Call().GetDTFromMVC(fieldDT, Request);
model.ModelID = modMod.ModelID;
model.ModelTable = modMod.TableName;
model.CUserID = mu.UserID;
model.LinkIds = RequestEx["LinkIds"];
if (model.ID < 1)
{
model.ID = clientBll.Insert(model, new DataTable());
}
else
{
M_CRMS_Client clientMod = clientBll.SelReturnModel(Mid);
model.ItemID = clientMod.ItemID;
model.CDate = clientMod.CDate;
model.CUserID = clientMod.CUserID;
model.Flow = clientMod.Flow;
clientBll.UpdateByID(model, new DataTable());
}
return(WriteOK("操作成功", "ConstPassen"));
}
public IActionResult AddConstPassen()
{
M_CRMS_Client clientMod = clientBll.SelReturnModel(Mid);
if (clientMod == null)
{
clientMod = new M_CRMS_Client();
}
return(View(clientMod));
}
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 int Insert(M_CRMS_Client model, DataTable table)
{
int itemid = 0;
if (!string.IsNullOrEmpty(model.ModelTable) && table.Rows.Count > 0)
{
itemid = DBCenter.Insert(model.ModelTable, BLLCommon.GetFields(table), BLLCommon.GetParas(table), BLLCommon.GetParameters(table).ToArray());
}
model.ItemID = itemid;
return(DBCenter.Insert(model));
}
public bool UpdateByID(M_CRMS_Client model, DataTable table)
{
int ItemID = model.ItemID;
if (table != null && table.Rows.Count > 0)
{
List <SqlParameter> splist = new List <SqlParameter>();
splist.AddRange(BLLCommon.GetParameters(table));
DBCenter.UpdateSQL(model.ModelTable, BLLCommon.GetFieldAndPara(table), "ID=" + ItemID, splist);
}
return(DBCenter.UpdateByID(model, model.ID));
}
public bool UpdateByID(M_CRMS_Client model)
{
return(DBCenter.UpdateByID(model, model.ID));
}
public int Insert(M_CRMS_Client model)
{
return(DBCenter.Insert(model));
}
