本文整理汇总了C#中CM_ClientBLL.Add方法的典型用法代码示例。如果您正苦于以下问题:C# CM_ClientBLL.Add方法的具体用法?C# CM_ClientBLL.Add怎么用?C# CM_ClientBLL.Add使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CM_ClientBLL
的用法示例。
在下文中一共展示了CM_ClientBLL.Add方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: RetailerAdd
/// <summary>
/// 新增门店资料
/// </summary>
/// <param name="User">用户</param>
/// <param name="TDP"></param>
/// <param name="ClientJson">门店资料Json</param>
/// <returns>大于0:新增的门店ID -1:Json字符串无法解析 -2:所属经销商无效 -3:新增门店基本资料失败</returns>
public static int RetailerAdd(UserInfo User, int TDP, ClientInfo Client, out string ErrorInfo)
{
ErrorInfo = "";
LogWriter.WriteLog("PBMIFService.RetailerAdd:UserName=" + User.UserName + ",TDP=" + TDP.ToString()
+ ",ClientInfo=" + JsonConvert.SerializeObject(Client));
if (User.OwnerType == 3) TDP = User.ClientID;
try
{
ClientInfo c = Client;
if (c == null) { ErrorInfo = "Json字符串无法解析"; return -1; } //Json字符串无法解析
CM_Client TDPClient = new CM_ClientBLL(TDP).Model;
if (TDPClient == null) { ErrorInfo = "所属经销商无效"; return -2; } //所属经销商无效
#region 判断必填与重复检测
if (c.FullName == "") { ErrorInfo = "门店名称必填"; return -10; }
if (c.Mobile == "") { ErrorInfo = "联系电话必填"; return -10; }
if (c.Address == "") { ErrorInfo = "门店地址必填"; return -10; }
if (c.Mobile.StartsWith("01")) c.Mobile = c.Mobile.Substring(1);
if (c.TeleNum.Contains("-")) c.TeleNum = c.TeleNum.Replace("-", "");
if (c.Mobile.Contains("-")) c.Mobile = c.Mobile.Replace("-", "");
//检查门店资料重复
int rptclientid = CM_ClientBLL.CheckRepeat(TDP, 0, c.Mobile, c.TeleNum, c.FullName, c.Address);
if (rptclientid > 0)
{
CM_Client _rptclient = new CM_ClientBLL(rptclientid).Model;
ErrorInfo = "门店资料与[" + _rptclient.FullName + "]资料重复,请勿重复新增!";
return -11;
}
#endregion
CM_ClientBLL bll = new CM_ClientBLL();
#region 门店基本资料
bll.Model.Code = c.Code;
bll.Model.FullName = c.FullName != "" ? c.FullName : c.ShortName;
bll.Model.ShortName = c.ShortName == "" ? c.FullName : c.ShortName;
if (c.OfficialCity > 0)
bll.Model.OfficialCity = c.OfficialCity;
else
bll.Model.OfficialCity = TDPClient.OfficialCity;
bll.Model.Address = c.Address;
bll.Model.DeliveryAddress = c.Address;
bll.Model.LinkManName = c.LinkManName;
bll.Model.TeleNum = c.TeleNum == "" ? c.Mobile : c.TeleNum;
if (c.Mobile.StartsWith("1") && c.Mobile.Length == 11) bll.Model.Mobile = c.Mobile;
bll.Model.OpenTime = DateTime.Parse("1900-01-01 08:00");
bll.Model.CloseTime = DateTime.Parse("1900-01-01 20:00");
bll.Model.ClientType = 3;
bll.Model.InsertStaff = User.StaffID;
bll.Model.OwnerType = 3;
bll.Model.OwnerClient = TDPClient.ID;
bll.Model.ApproveFlag = 2; //默认为未审核
#endregion
int retailerid = bll.Add();
if (retailerid < 0) { ErrorInfo = "新增门店基本资料失败"; return -3; } //新增门店基本资料失败
#region 设置供货商信息
CM_ClientSupplierInfo supplierinfo = new CM_ClientSupplierInfo();
supplierinfo.Code = c.CodeBySupplier;
supplierinfo.Client = retailerid;
supplierinfo.Supplier = TDP;
if (User.OwnerType == 3)
{
supplierinfo.Salesman = User.StaffID;
IList<VST_Route> routes = VST_RouteBLL.GetRouteListByStaff(User.StaffID);
if (routes.Count > 0) supplierinfo.VisitRoute = routes[0].ID;
}
supplierinfo.StandardPrice = c.StandardPrice;
supplierinfo.TDPChannel = c.TDPChannel;
supplierinfo.TDPSalesArea = c.TDPSalesArea;
supplierinfo.VisitSequence = c.VisitSequence;
supplierinfo.VisitTemplate = c.VisitTemplate;
supplierinfo.InsertStaff = User.StaffID;
bll.SetSupplierInfo(supplierinfo);
#endregion
#region 设置厂商管理信息
CM_ClientManufactInfo manufactinfo = new CM_ClientManufactInfo();
manufactinfo.Client = retailerid;
manufactinfo.Code = c.CodeByManufaturer;
manufactinfo.Manufacturer = TDPClient.OwnerClient; //门店归属厂商默认为经销商资料的所属厂商
if (User.OwnerType == 2)
{
manufactinfo.ClientManager = User.StaffID;
//.........这里部分代码省略.........
示例2: DoImportClient
public string DoImportClient(int TemplateID, int Client, ISheet Sheet, out int State)
{
string ImportInfo = "【客户资料】Excel表:";
State = 0;
IPT_UploadTemplateBLL _template = new IPT_UploadTemplateBLL(TemplateID);
List<string> listClient = new List<string>() { "序号", "区域", "渠道", "客户编号", "客户名称", "联系人", "地址", "电话", "手机", "销售线路", "备注" };
DataTable dt = null;
bool flag = VertifySheet(Sheet, listClient, out dt, ref ImportInfo);
if (!flag) { State = 4; return ImportInfo; }
foreach (DataRow dr in dt.Rows)//循环导入数据
{
try
{
string _ClientCode = dr["客户编号"].ToString();//客户自编码
string _ClientName = dr["客户名称"].ToString();
if (string.IsNullOrEmpty(_ClientCode))// && string.IsNullOrEmpty(_ClientName)
{
ImportInfo += "导入序列号为" + dr["序号"].ToString() + "的数据行时找不到门店编码,跳过此行记录\r\n";//门店名称和
continue;
}
IList<CM_Client> _listClient = CM_ClientBLL.GetModelList(" ApproveFlag=1 AND ClientType=3 AND OwnerType=3 AND OwnerClient=" + _template.Model.ClientID + "AND EXISTS(SELECT 1 FROM MCS_CM.dbo.CM_ClientSupplierInfo WHERE Supplier=" + _template.Model.ClientID + " AND Client= CM_Client.id AND Code=" + _ClientCode + " ) ");
if (_listClient != null && _listClient.Count > 0)
{
ImportInfo += "导入序列号为" + dr["序号"].ToString() + "的数据行时找到相同编码的门店,跳过此行记录\r\n";
continue;
}
string _ClientLinkMan = dr["联系人"].ToString();
string _ClientAddress = dr["地址"].ToString();
string _ClientTel = dr["电话"].ToString();
string _ClientMobile = dr["手机"].ToString();
#region 获取线路
string _strClientVisitRoute = dr["销售线路"].ToString();//业务拜访模板Code
VST_Route _route = null;
if (!string.IsNullOrEmpty(_strClientVisitRoute))//优先匹配厂商级的拜访记录
{
_route = VST_RouteBLL.GetModelList(" OwnerType IN(1,2) AND Code='" + _strClientVisitRoute + "'").FirstOrDefault();//IList<VST_Route>_listRoute
if (_route == null)//找不到厂商级的线路找经销商级别的
{
_route = VST_RouteBLL.GetModelList(" OwnerType=3 AND OwnerClient=" + _template.Model.ClientID + " AND Code='" + _strClientVisitRoute + "'").FirstOrDefault();
}
}
/*模板中存在负责业务时获取门店业代和拜访记录代码
int _ClientSalesMan = 0;//负责业务
int _ClientVisitRoute = 0;//业务拜访模板ID
string _strClientSalesMan = dr["负责业务"].ToString();
if (!string.IsNullOrEmpty(_strClientSalesMan))
{
IList<Org_Staff> _listStaff = Org_StaffBLL.GetStaffList(" OwnerClient=" + _template.Model.ClientID + " AND OwnerType=3 AND RealName='" + _strClientSalesMan + "'");
if (_listStaff != null && _listStaff.Count > 0)
{
_ClientSalesMan = _listStaff[0].ID;
IList<VST_Route> _listRoute = VST_RouteBLL.GetModelList(" OwnerClient=" + _template.Model.ClientID + " AND RelateStaff=" + _ClientSalesMan);
if (_listRoute != null && _listRoute.Count > 0) _ClientVisitRoute = _listRoute[0].ID;
}
else
{
Org_StaffBLL _bllStaff = new Org_StaffBLL();
CM_ClientBLL c = new CM_ClientBLL(_template.Model.ClientID);
CM_ClientManufactInfo manufactinfo = c.GetManufactInfo();
if (c != null && manufactinfo != null)
{
_bllStaff.Model.OrganizeCity = manufactinfo.OrganizeCity;
_bllStaff.Model.OfficialCity = c.Model.OfficialCity;
}
_bllStaff.Model.RealName = _strClientSalesMan;
_bllStaff.Model.Position = 1030;//默认为业务员
_bllStaff.Model.InsertStaff = _template.Model.InsertStaff;
_bllStaff.Model.OwnerClient = _template.Model.ClientID;
_bllStaff.Model.OwnerType = 3;
_bllStaff.Model.Dimission = 1;
_bllStaff.Model.ApproveFlag = 1;
_ClientSalesMan = _bllStaff.Add();
//创建默认员工线路
if (_ClientSalesMan > 0)
{
if (_bllStaff.Model.Position == 1030)
{
VST_RouteBLL routebll = new VST_RouteBLL();
routebll.Model.Code = "R" + _ClientSalesMan.ToString();
routebll.Model.Name = "线路-" + _bllStaff.Model.RealName;
routebll.Model.RelateStaff = _ClientSalesMan;
routebll.Model.OrganizeCity = _bllStaff.Model.OrganizeCity;
routebll.Model.OwnerClient = _template.Model.ClientID;
routebll.Model.OwnerType = 3;
routebll.Model.ApproveFlag = 1;
routebll.Model.EnableFlag = "Y";
routebll.Model.InsertStaff = _template.Model.InsertStaff;
_ClientVisitRoute = routebll.Add();
}
}
}
}*/
#endregion
string _ClientRemark = dr["备注"].ToString();
//.........这里部分代码省略.........
示例3: DoImportSupplier
public string DoImportSupplier(int TemplateID, int Client, ISheet Sheet, out int State)
{
string ImportInfo = "【供货单位信息】Excel表:";
State = 0;
IPT_UploadTemplateBLL _template = new IPT_UploadTemplateBLL(TemplateID);
List<string> listSupplier = new List<string>() { "序号", "客户名称", "地址", "联系人", "电话" };
DataTable dt = null;
bool flag = VertifySheet(Sheet, listSupplier, out dt, ref ImportInfo);
if (!flag) { State = 4; return ImportInfo; }
foreach (DataRow dr in dt.Rows)//循环导入数据
{
try
{
string _SupplierName = dr["客户名称"].ToString();
string _SupplierAddress = dr["地址"].ToString();
string _SupplierTeleNum = dr["电话"].ToString();
string _SupplierLinkMan = dr["联系人"].ToString();
if (string.IsNullOrEmpty(_SupplierName))
{
ImportInfo += string.Format("序号为{0}的行客户名称均为空,跳过此行信息\r\n", dr["序号"]);
continue;
}
IList<CM_Client> _listClient = CM_ClientBLL.GetModelList(" ClientType=1 AND OwnerType=3 AND OwnerClient=" + _template.Model.ClientID.ToString() + " AND FullName='" + _SupplierName + "'");
if (_listClient != null && _listClient.Count > 0)
{
ImportInfo += string.Format("序号为{0},名称为{1}的客户已存在,跳过此行信息\r\n", dr["序号"], _SupplierName);
continue;
}
CM_ClientBLL _bllClient = new CM_ClientBLL();
_bllClient.Model.FullName = _SupplierName;
_bllClient.Model.ShortName = _SupplierName;
_bllClient.Model.Address = _SupplierAddress;
_bllClient.Model.TeleNum = _SupplierTeleNum;
_bllClient.Model.Remark = "Excel批量导入";
_bllClient.Model.ClientType = 1;
_bllClient.Model.OwnerType = 3;
_bllClient.Model.OwnerClient = _template.Model.ClientID;
_bllClient.Add();
}
catch (Exception ex)
{
ImportInfo += "导入序列号为" + dr["序号"].ToString() + "的数据行时出现错误,错误说明:" + ex.Message + "\r\n";
State = 5;
continue;
}
}
if (State == 0) State = 3;
ImportInfo += (State == 3 ? "导入完成!\r\n" : "");
IPT_UploadTemplateMessageBLL _bllUploadTemplateMessage = new IPT_UploadTemplateMessageBLL();
_bllUploadTemplateMessage.Model.TemplateID = TemplateID;
_bllUploadTemplateMessage.Model.MessageType = State;
_bllUploadTemplateMessage.Model.Content = ImportInfo;
_bllUploadTemplateMessage.Add();
return ImportInfo;
}
示例4: threadStartImport
private void threadStartImport(BackgroundWorker worker, DoWorkEventArgs e)
{
DataTable dt_OfficialCity = Addr_OfficialCityBLL.GetAllOfficialCity();
DataTable dt_OrganizeCity = Addr_OrganizeCityBLL.GetAllOrganizeCity();
DataTable dt_Position = Org_PositionBLL.GetAllPostion();
bool bFind = false;
StringBuilder _xhs_success = new StringBuilder("");//成功导入的记录序号(用于定期批量更新导入标志)
string XH = "";
#region 导入销售人员资料
try
{
if (cbx_Promotor.Checked)
{
lb_Count.Text = dt_SalesStaff.Rows.Count.ToString();
tabControl1.SelectedIndex = 0;
XH = "";
for (int i = 0; i < dt_SalesStaff.Rows.Count; i++)
{
worker.ReportProgress((i + 1) * 100 / this.dt_SalesStaff.Rows.Count, i);
if (worker.CancellationPending)
{
e.Cancel = true;
break;
}
XH = dt_SalesStaff.Rows[i]["序号"].ToString();
Org_StaffBLL staff = new Org_StaffBLL();
//序号
if (dt_SalesStaff.Rows[i]["员工工号"].ToString() != "")
staff.Model["StaffCode"] = dt_SalesStaff.Rows[i]["员工工号"].ToString();
else
staff.Model["StaffCode"] = FormatClientCode('S', dt_SalesStaff.Rows[i]["序号"].ToString().Trim(), dt_SalesStaff.Rows[i]["管理片区代码"].ToString().Trim());
#region 判断数据是否重复
if (Org_StaffBLL.GetStaffList("StaffCode = '" + staff.Model["StaffCode"] + "'").Count > 0)
{
UpdateImportFlag(1, i, "导入失败,数据重复!");
continue;
}
#endregion
//姓名
staff.Model["RealName"] = dt_SalesStaff.Rows[i]["姓名"].ToString().Trim();
//职务
DataRow[] rows_Position = dt_Position.Select("Name = '" + dt_SalesStaff.Rows[i]["职务"].ToString().Trim() + "'");
if (rows_Position.Length == 0)
{
UpdateImportFlag(1, i, "导入失败,职务在系统字典中不存在!");
continue;
}
else
staff.Model["Position"] = rows_Position[0]["ID"].ToString().Trim();
//管理片区代码
DataRow[] rows_OrganizeCity = dt_OrganizeCity.Select("Code='" + dt_SalesStaff.Rows[i]["管理片区代码"].ToString().Trim() + "'");
if (rows_OrganizeCity.Length == 0)
{
UpdateImportFlag(1, i, "导入失败,管理片区代码在系统字典中不存在!");
continue;
}
else
staff.Model["OrganizeCity"] = rows_OrganizeCity[0]["ID"].ToString().Trim();
//性别
staff.Model["Sex"] = dt_SalesStaff.Rows[i]["性别"].ToString();
//bFind = false;
//foreach (Dictionary_Data item in DictionaryBLL.GetDicCollections("Pub_Sex").Values)
//{
// if (item.Name == dt_SalesStaff.Rows[i]["性别"].ToString().Trim())
// {
// staff.Model["Sex"] = item.Code;
// bFind = true;
// break;
// }
//}
//if (!bFind)
//{
// UpdateImportFlag(1, i, "导入失败,性别在系统字典中不存在!");
// continue;
//}
//联系电话
staff.Model["TeleNum"] = dt_SalesStaff.Rows[i]["联系电话"].ToString().Trim();
//手机
staff.Model["Mobile"] = dt_SalesStaff.Rows[i]["手机"].ToString().Trim();
//城市
string cityname = dt_SalesStaff.Rows[i]["城市"].ToString().Trim();
if (cityname.Length > 3) cityname = cityname.Substring(0, 3);
DataRow[] rows_OfficialCity = dt_OfficialCity.Select("Name like '" + cityname + "%'");
if (rows_OfficialCity.Length == 0)
{
UpdateImportFlag(1, i, "导入失败,城市在系统字典中不存在!");
continue;
}
else
//.........这里部分代码省略.........