protected void bt_OK_Click(object sender, EventArgs e)
{
CM_RTChannel_TDPBLL _bll;
if ((int)ViewState["ID"] != 0)
{
//修改
_bll = new CM_RTChannel_TDPBLL((int)ViewState["ID"]);
}
else
{
//新增
_bll = new CM_RTChannel_TDPBLL();
}
pl_detail.GetData(_bll.Model);
#region 判断必填项
#endregion
if ((int)ViewState["ID"] != 0)
{
//修改
_bll.Model.InsertStaff = (int)Session["UserID"];
if (_bll.Update() == 0)
{
MessageBox.ShowAndRedirect(this, "修改成功!", "RTChannelList.aspx");
}
}
else
{
//新增
TextBox ddl_Name = (TextBox)pl_detail.FindControl("CM_RTChannel_TDP_Name");
IList <CM_RTChannel_TDP> ddl_Name_01 = CM_RTChannel_TDPBLL.GetModelList("Name='" + ddl_Name.Text.ToString() + "'" + "and OwnerClient=" + Session["OwnerClient"].ToString());
if (ddl_Name_01.Count <= 0)//判断渠道是否已经存在
{
_bll.Model.InsertStaff = (int)Session["UserID"];
_bll.Model.OwnerClient = (int)Session["OwnerClient"];
ViewState["ID"] = _bll.Add();
}
else
{
MessageBox.Show(this, "渠道已存在！");
}
if ((int)ViewState["ID"] > 0)
{
MessageBox.ShowAndRedirect(this, "新增成功!", "RTChannelList.aspx");
}
}
}
public void BindDropDown()
{
#region 业务人员
DropDownList ddlSalesMan = pl_detail.FindControl("CM_ClientSupplierInfo_Salesman") as DropDownList;
if (ddlSalesMan != null)
{
ddlSalesMan.DataTextField = "RealName";
ddlSalesMan.DataValueField = "ID";
IList <Org_Staff> listStaff = Org_StaffBLL.GetStaffList("Dimission=1 AND Position=1030 AND OwnerClient= " + Session["OwnerClient"].ToString());
if (listStaff == null)
{
listStaff = new List <Org_Staff>(1);
}
listStaff.Insert(0, new Org_Staff {
RealName = "请选择", ID = 0
});
ddlSalesMan.DataSource = listStaff;
ddlSalesMan.DataBind();
}
#endregion
#region 经销商自分渠道
DropDownList ddlTDPChannel = pl_detail.FindControl("CM_ClientSupplierInfo_TDPChannel") as DropDownList;
if (ddlTDPChannel != null)
{
ddlTDPChannel.DataTextField = "Name";
ddlTDPChannel.DataValueField = "ID";
IList <CM_RTChannel_TDP> listChannel = CM_RTChannel_TDPBLL.GetModelList("OwnerClient= " + Session["OwnerClient"].ToString());
if (listChannel == null)
{
listChannel = new List <CM_RTChannel_TDP>(1);
}
listChannel.Insert(0, new CM_RTChannel_TDP {
Name = "请选择", ID = 0
});
ddlTDPChannel.DataSource = listChannel;
ddlTDPChannel.DataBind();
}
#endregion
#region 经销商所属区域
DropDownList ddlTDPSalesArea = pl_detail.FindControl("CM_ClientSupplierInfo_TDPSalesArea") as DropDownList;
if (ddlTDPSalesArea != null)
{
ddlTDPSalesArea.DataTextField = "Name";
ddlTDPSalesArea.DataValueField = "ID";
IList <CM_RTSalesArea_TDP> listSalesArea = CM_RTSalesArea_TDPBLL.GetModelList("OwnerClient= " + Session["OwnerClient"].ToString());
if (listSalesArea == null)
{
listSalesArea = new List <CM_RTSalesArea_TDP>(1);
}
listSalesArea.Insert(0, new CM_RTSalesArea_TDP {
Name = "请选择", ID = 0
});
ddlTDPSalesArea.DataSource = listSalesArea;
ddlTDPSalesArea.DataBind();
}
#endregion
#region 经销商价表
DropDownList ddlStandardPrice = pl_detail.FindControl("CM_ClientSupplierInfo_StandardPrice") as DropDownList;
if (ddlStandardPrice != null)
{
ddlStandardPrice.DataTextField = "Name";
ddlStandardPrice.DataValueField = "ID";
IList <PDT_StandardPrice> listPrice = PDT_StandardPriceBLL.GetAllPrice_BySupplier((int)Session["OwnerClient"]);
if (listPrice == null)
{
listPrice = new List <PDT_StandardPrice>(1);
}
listPrice.Insert(0, new PDT_StandardPrice {
Name = "请选择", ID = 0
});
ddlStandardPrice.DataSource = listPrice;
ddlStandardPrice.DataBind();
}
#endregion
#region 经销商自营路线
DropDownList ddlVisitRoute = pl_detail.FindControl("CM_ClientSupplierInfo_VisitRoute") as DropDownList;
if (ddlVisitRoute != null)
{
ddlVisitRoute.DataTextField = "Name";
ddlVisitRoute.DataValueField = "ID";
IList <VST_Route> listRoute = VST_RouteBLL.GetRouteListByTDP((int)Session["OwnerClient"]);
listRoute.Insert(0, new VST_Route {
Name = "请选择", ID = 0
});
ddlVisitRoute.DataSource = listRoute;
ddlVisitRoute.DataBind();
}
#endregion
#region 行政城市默认为厂商所在省份
MCSTreeControl tr_OfficialCity = (MCSTreeControl)pl_detail.FindControl("CM_Client_OfficialCity");
if (tr_OfficialCity != null)
{
if ((int)Session["Manufacturer"] > 0)
{
CM_Client c = new CM_ClientBLL((int)Session["Manufacturer"]).Model;
if (c != null)
{
int prov = TreeTableBLL.GetSuperIDByLevel("MCS_SYS.dbo.Addr_OfficialCity", c.OfficialCity, 1);
tr_OfficialCity.RootValue = prov.ToString();
}
}
}
#endregion
}
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();
int _OwnerClient = _template.Model.ClientID;
#region 获取所在区域
int _SalesArea = 0;//区域
string _strSalesArea = dr["区域"].ToString();
if (!string.IsNullOrEmpty(_strSalesArea))
{
IList <CM_RTSalesArea_TDP> _listSalesArea = CM_RTSalesArea_TDPBLL.GetModelList(" OwnerClient= " + _OwnerClient.ToString() + " AND Name='" + _strSalesArea + "' ");
if (_listSalesArea != null && _listSalesArea.Count > 0)
{
_SalesArea = _listSalesArea[0].ID;
}
else
{
CM_RTSalesArea_TDPBLL _bllRTSalesArea_TDPBLL = new CM_RTSalesArea_TDPBLL();
_bllRTSalesArea_TDPBLL.Model.Name = _strSalesArea;
_bllRTSalesArea_TDPBLL.Model.OwnerClient = _OwnerClient;
_bllRTSalesArea_TDPBLL.Model.Remark = "Excel批量导入";
_bllRTSalesArea_TDPBLL.Model.InsertStaff = _template.Model.InsertStaff;
_bllRTSalesArea_TDPBLL.Model.InsertTime = DateTime.Now;
_SalesArea = _bllRTSalesArea_TDPBLL.Add();
}
}
#endregion
#region 获取所在渠道
int _RTChannel = 0;//渠道
string _strRTChannel = dr["渠道"].ToString();
if (!string.IsNullOrEmpty(_strRTChannel))
{
IList <CM_RTChannel_TDP> _listRTChannel = CM_RTChannel_TDPBLL.GetModelList(" OwnerClient= " + _OwnerClient.ToString() + " AND Name='" + _strRTChannel + "' ");
if (_listRTChannel != null && _listRTChannel.Count > 0)
{
_RTChannel = _listRTChannel[0].ID;
}
else
{
CM_RTChannel_TDPBLL _bllRTSalesArea_TDPBLL = new CM_RTChannel_TDPBLL();
_bllRTSalesArea_TDPBLL.Model.Name = _strRTChannel;
_bllRTSalesArea_TDPBLL.Model.OwnerClient = _OwnerClient;
_bllRTSalesArea_TDPBLL.Model.Remark = "Excel批量导入";
_bllRTSalesArea_TDPBLL.Model.InsertStaff = _template.Model.InsertStaff;
_bllRTSalesArea_TDPBLL.Model.InsertTime = DateTime.Now;
_RTChannel = _bllRTSalesArea_TDPBLL.Add();
}
}
#endregion
CM_ClientBLL _bll = new CM_ClientBLL();//Client表Code字段暂不启用，以FactoryCode作为厂商编码。经销商对门店的编码存于CM_ClientSupplierInfo表的Code字段
_bll.Model.FullName = _ClientName;
_bll.Model.ShortName = _ClientName;
_bll.Model.LinkManName = _ClientLinkMan;
_bll.Model.Address = _ClientAddress;
_bll.Model.TeleNum = _ClientTel;
_bll.Model.Mobile = _ClientMobile;
_bll.Model.Remark = string.IsNullOrEmpty(_ClientRemark) ? "Excel批量导入" : _ClientRemark;
_bll.Model.ClientType = 3;
_bll.Model.ApproveFlag = 1;
_bll.Model.InsertStaff = _template.Model.InsertStaff;
_bll.Model.OwnerType = 3; //所属经销商
_bll.Model.OwnerClient = _OwnerClient;
int _ClientID = _bll.Add();
if (_ClientID > 0)
{
CM_ClientSupplierInfo _Supplierinfo = _bll.GetSupplierInfo(_OwnerClient);
if (_Supplierinfo == null)
{
_Supplierinfo = new CM_ClientSupplierInfo();
_Supplierinfo.Supplier = _OwnerClient;
}
_Supplierinfo.TDPChannel = _RTChannel;
_Supplierinfo.TDPSalesArea = _SalesArea;
_Supplierinfo.Code = _ClientCode;
_Supplierinfo.Remark = _ClientRemark;
CM_ClientBLL s = new CM_ClientBLL(_OwnerClient);
CM_ClientManufactInfo _manufactinfo = _bll.GetManufactInfo(s.Model.OwnerClient);
if (_manufactinfo == null)
{
_manufactinfo = new CM_ClientManufactInfo();
//门店所属区域为经销商对应区域
_manufactinfo.Manufacturer = s.Model.OwnerClient;
_manufactinfo.OrganizeCity = s.GetManufactInfo().OrganizeCity;
}
if (_route != null && _route.OwnerType == 3)//线路为经销商级别的存放在经销商表中
{
_Supplierinfo.VisitRoute = _route.ID;
}
else if (_route != null && (_route.OwnerType == 1 || _route.OwnerType == 2))//线路为厂商级别的存放在经销商表中
{
_manufactinfo.VisitRoute = _route.ID;
}
_bll.SetSupplierInfo(_Supplierinfo);
_bll.SetManufactInfo(_manufactinfo);
}
}
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);
}