private void CustBaseInfoBind()
{
Entities.GroupOrder custBasicInfo = BLL.GroupOrder.Instance.GetGroupOrderCustInfo(RequestTaskID);
if (custBasicInfo != null)
{
CustName = custBasicInfo.CustomerName;
if (custBasicInfo.UserGender == 1)
{
Sex = "先生";
}
else if (custBasicInfo.UserGender == 2)
{
Sex = "女士";
}
if (custBasicInfo.ProvinceID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.ProvinceID.ToString());
}
if (custBasicInfo.CityID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
PlaceStr += " " + BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaName(custBasicInfo.CityID.ToString());
}
//大区查询 强斐 2014-12-17
BitAuto.YanFa.Crm2009.Entities.AreaInfo info = BLL.Util.GetAreaInfoByPCC(
BitAuto.ISDC.CC2012.Entities.CommonFunction.ObjectToString(custBasicInfo.ProvinceID),
BitAuto.ISDC.CC2012.Entities.CommonFunction.ObjectToString(custBasicInfo.CityID), null);
AreaStr = info == null ? "" : info.DistinctName;
Tels = custBasicInfo.CustomerTel;
lblUserName.Text = custBasicInfo.UserName;
}
}
/// <summary>
/// 根据易湃团购订单实体信息，插入表GroupOrder信息
/// </summary>
/// <param name="tran"></param>
/// <param name="taskID">任务ID</param>
/// <param name="model">易湃团购订单实体信息</param>
/// <returns></returns>
public bool InsertByTaskID(SqlTransaction tran, long taskID, Entities.GroupOrderOrg model)
{
Entities.GroupOrder onModel = new Entities.GroupOrder();
onModel.TaskID = taskID;
onModel.OrderID = model.OrderID;
onModel.OrderCode = model.OrderCode;
onModel.CustomerName = model.CustomerName.Trim();
onModel.CustomerTel = model.CustomerTel.Trim();
onModel.ProvinceID = model.ProvinceID;
onModel.ProvinceName = model.ProvinceName;
onModel.CityID = model.CityID;
onModel.CityName = model.CityName;
//修改大区 强斐 2014-12-17
BitAuto.YanFa.Crm2009.Entities.AreaInfo info = Util.GetAreaInfoByPCC(
CommonFunction.ObjectToString(model.ProvinceID),
CommonFunction.ObjectToString(model.CityID),
null);
onModel.AreaID = info == null ? "" : info.District;
onModel.OrderCreateTime = model.OrderCreateTime;
onModel.CarMasterID = model.CarMasterID;
onModel.CarMasterName = model.CarMasterName;
onModel.CarSerialID = model.CarSerialID;
onModel.CarSerialName = model.CarSerialName;
onModel.CarID = model.CarID;
onModel.CarName = model.CarName;
onModel.DealerID = model.DealerID;
onModel.DealerName = model.DealerName;
onModel.OrderPrice = model.Price;
onModel.CreateTime = DateTime.Now;
onModel.CreateUserID = null;
onModel.LastUpdateTime = null;
onModel.LastUpdateUserID = null;
onModel.UserName = null;
long recid = Insert(tran, onModel);
if (recid > 0)
{
BLL.Loger.Log4Net.Info(string.Format("团购任务生成表GroupOrder成功，主键ID为：{0},无主订单ID为：{1},车款ID：{2},子品牌ID：{3}，主品牌ID为：{4}",
recid, onModel.OrderID,
onModel.CarID == null ? 0 : onModel.CarID.Value,
onModel.CarSerialID == null ? 0 : onModel.CarSerialID.Value,
onModel.CarMasterID == null ? 0 : onModel.CarMasterID.Value
));
return(true);
}
return(false);
}
/// 根据 省 城市 区县 重新计算大区信息
/// <summary>
/// 根据 省 城市 区县 重新计算大区信息
/// qiangfei
/// 2014-12-17
/// </summary>
/// <param name="model"></param>
public void ReCalcAreaDistrict(Entities.CustBasicInfo model)
{
BitAuto.YanFa.Crm2009.Entities.AreaInfo info = Util.GetAreaInfoByPCC(
CommonFunction.ObjectToString(model.ProvinceID),
CommonFunction.ObjectToString(model.CityID),
CommonFunction.ObjectToString(model.CountyID));
if (info != null)
{
model.AreaID = info.District;
}
else
{
model.AreaID = "";
}
}
//获取地区字符串
private string GetRegionString(string provinceID, string cityID, string CountyID)
{
string regionStr = "";
string provinceName = "";
string cityName = "";
string countyName = "";
BitAuto.YanFa.Crm2009.Entities.AreaInfo provinceAreaInfo = new BitAuto.YanFa.Crm2009.Entities.AreaInfo();
provinceAreaInfo = BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaInfo(provinceID);
if (provinceAreaInfo != null)
{
provinceName = provinceAreaInfo.AreaName;
}
else
{
provinceName = provinceID;
}
BitAuto.YanFa.Crm2009.Entities.AreaInfo cityAreaInfo = new BitAuto.YanFa.Crm2009.Entities.AreaInfo();
cityAreaInfo = BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaInfo(cityID);
if (cityAreaInfo != null)
{
cityName = cityAreaInfo.AreaName;
}
else
{
cityName = cityID;
}
BitAuto.YanFa.Crm2009.Entities.AreaInfo countyAreaInfo = new BitAuto.YanFa.Crm2009.Entities.AreaInfo();
countyAreaInfo = BitAuto.YanFa.Crm2009.BLL.AreaInfo.Instance.GetAreaInfo(CountyID);
if (countyAreaInfo != null)
{
countyName = countyAreaInfo.AreaName;
}
else
{
countyName = CountyID;
}
regionStr = provinceName + " " + cityName + " " + countyName;
return(regionStr);
}
private void WorkOrderBind()
{
QueryWorkOrderInfo query = BLL.Util.BindQuery <QueryWorkOrderInfo>(this.Context);
int userId = BLL.Util.GetLoginUserID();
query.LoginID = userId;
#region 数据权限
////判断当前人是否有全部数据权限
//int RightType = (int)BLL.UserDataRigth.Instance.GetUserDataRigth(userId).RightType;
////如果没有
//if (RightType != 2)
//{
// DataTable dtBusiness = BLL.BusinessGroup.Instance.GetBusinessGroupByName("工单组");
// if (dtBusiness != null && dtBusiness.Rows.Count > 0)
// {
// //取当前人所对应的数据权限组
// Entities.QueryUserGroupDataRigth QueryUserGroupDataRigth = new Entities.QueryUserGroupDataRigth();
// QueryUserGroupDataRigth.UserID = userId;
// QueryUserGroupDataRigth.BGID = int.Parse(dtBusiness.Rows[0]["BGID"].ToString());
// int totcount = 0;
// DataTable dtUserGroupDataRigth = BLL.UserGroupDataRigth.Instance.GetUserGroupDataRigth(QueryUserGroupDataRigth, "", 1, 100000, out totcount);
// string Rolename = string.Empty;
// if (dtUserGroupDataRigth != null && dtUserGroupDataRigth.Rows.Count > 0)
// {
// if (dtUserGroupDataRigth.Rows[0]["RightType"].ToString() == "1") //本人权限
// {
// query.RightType = 1;
// }
// else //本组权限
// {
// query.RightType = 0;
// }
// }
// else //如果没有数据权限
// {
// //-1表示没有权限
// query.RightType = -1;
// }
// }
// else
// {
// query.RightType = -1;
// }
//}
#endregion
string orderstring = "";
if (RequestOrderCreateTime == "1")
{
//orderstring = "Order By OrderNum ASC,woi.CreateTime Desc,woi.LastProcessDate ASC";
orderstring = "Order By OrderNum ASC,CreateTime Desc,LastProcessDate ASC";
}
else
{
//orderstring = "Order By OrderNum ASC,woi.LastProcessDate ASC,woi.CreateTime Desc";
orderstring = "Order By OrderNum ASC,LastProcessDate ASC,CreateTime Desc";
}
//DataTable dt = BLL.WorkOrderInfo.Instance.GetWorkOrderInfoForExport(query, (int)query.WorkCategory, userId, "Order By OrderNum ASC,LastProcessDate ASC");
DataTable dt = BLL.WorkOrderInfo.Instance.GetWorkOrderInfoForExport(query, (int)query.WorkCategory, userId, orderstring);
DataTable dtNew = new DataTable();
DataColumn dcOrderID = new DataColumn("工单ID");
dtNew.Columns.Add(dcOrderID);
//工单类型：1个人，2经销商
DataColumn dcWorkCategory = new DataColumn("工单类型");
dtNew.Columns.Add(dcWorkCategory);
DataColumn dcOrderCategory = new DataColumn("工单分类");
dtNew.Columns.Add(dcOrderCategory);
DataColumn dcDataSource = new DataColumn("数据来源");
dtNew.Columns.Add(dcDataSource);
DataColumn dcTitle = new DataColumn("工单标题");
dtNew.Columns.Add(dcTitle);
DataColumn dcCustName = new DataColumn("客户名称");
DataColumn dcProvincel = new DataColumn("省份");
DataColumn dcCity = new DataColumn("城市");
DataColumn dcCounty = new DataColumn("区县");
DataColumn dcAreaName = new DataColumn("大区");
DataColumn dcContact = new DataColumn("联系人");
DataColumn dcContactTel = new DataColumn("联系电话");
//add 是否接通和未接通原因 by anyy 2015-11-20
DataColumn dcIsEstablish = new DataColumn("是否接通");
DataColumn dcNotEstablishReason = new DataColumn("未接通原因");
DataColumn dcTag = new DataColumn("标签");
DataColumn dcType = new DataColumn("是否投诉");
DataColumn dcPriorityLevel = new DataColumn("优先级");
DataColumn dcLastDate = new DataColumn("最晚处理时间");
DataColumn dcWorkOrderStatus = new DataColumn("工单状态");
DataColumn dcContent = new DataColumn("工单记录");
DataColumn dcReceiver = new DataColumn("处理人");
DataColumn dcReceiverDepartName = new DataColumn("处理人所属部门");
DataColumn dcIsSales = new DataColumn("是否为营销顾问");
DataColumn dcAttentionCarBrandName = new DataColumn("关注车型品牌名称");
DataColumn dcAttentionCarSerialName = new DataColumn("关注车型系列名称");
DataColumn dcAttentionCarTypeName = new DataColumn("关注车型车款名称");
DataColumn dcSelectDealerName = new DataColumn("工单推荐经销商名称");
DataColumn dcIsReturnVisit = new DataColumn("是否接受回访");
DataColumn dcNominateActivity = new DataColumn("推荐活动");
DataColumn dcSaleCarBrandName = new DataColumn("出售车型品牌名称");
DataColumn dcSaleCarSerialName = new DataColumn("出售车型系列名称");
DataColumn dcSaleCarTypeName = new DataColumn("出售车型车款名称");
DataColumn dcIsRevert = new DataColumn("是否有回复");
if (query.WorkCategory == 1)//个人工单
{
dtNew.Columns.Add(dcTag);
dtNew.Columns.Add(dcContent);
dtNew.Columns.Add(dcAttentionCarBrandName);
dtNew.Columns.Add(dcAttentionCarSerialName);
dtNew.Columns.Add(dcAttentionCarTypeName);
dtNew.Columns.Add(dcSelectDealerName);
dtNew.Columns.Add(dcIsReturnVisit);
dtNew.Columns.Add(dcNominateActivity);
dtNew.Columns.Add(dcSaleCarBrandName);
dtNew.Columns.Add(dcSaleCarSerialName);
dtNew.Columns.Add(dcSaleCarTypeName);
dtNew.Columns.Add(dcProvincel);
dtNew.Columns.Add(dcCity);
dtNew.Columns.Add(dcAreaName);
}
else//经销商工单
{
dtNew.Columns.Add(dcCustName);
dtNew.Columns.Add(dcProvincel);
dtNew.Columns.Add(dcCity);
dtNew.Columns.Add(dcCounty);
dtNew.Columns.Add(dcAreaName);
dtNew.Columns.Add(dcContact);
dtNew.Columns.Add(dcContactTel);
//客户回访的订单全是经销商的，有是否接通和未接通原因
dtNew.Columns.Add(dcIsEstablish);
dtNew.Columns.Add(dcNotEstablishReason);
dtNew.Columns.Add(dcTag);
dtNew.Columns.Add(dcType);
dtNew.Columns.Add(dcPriorityLevel);
dtNew.Columns.Add(dcLastDate);
dtNew.Columns.Add(dcWorkOrderStatus);
dtNew.Columns.Add(dcContent);
dtNew.Columns.Add(dcReceiver);
dtNew.Columns.Add(dcReceiverDepartName);
dtNew.Columns.Add(dcIsSales);
dtNew.Columns.Add(dcIsRevert);
}
DataColumn dcLastOptTime = new DataColumn("最后操作时间");
dtNew.Columns.Add(dcLastOptTime);
DataColumn dcCreateUser = new DataColumn("操作人");
dtNew.Columns.Add(dcCreateUser);
DataColumn dcCreateTime = new DataColumn("提交日期");
dtNew.Columns.Add(dcCreateTime);
foreach (DataRow dr in dt.Rows)
{
//dt.Columns[0].ColumnName
DataRow drNew = dtNew.NewRow();
//工单类型
if (dr["WorkCategory"].ToString() == "1")
{
drNew[dcWorkCategory] = "个人";
}
else if (dr["WorkCategory"].ToString() == "2")
{
drNew[dcWorkCategory] = "经销商";
}
drNew[dcOrderID] = dr["OrderID"].ToString();
drNew[dcOrderCategory] = dr["CategoryName"].ToString();
drNew[dcDataSource] = BLL.Util.GetEnumOptText(typeof(Entities.WorkOrderDataSource), int.Parse(dr["DataSource"].ToString()));
drNew[dcTitle] = dr["Title"].ToString();
if (query.WorkCategory == 1)
{
drNew[dcTag] = dr["TagName"].ToString();
drNew[dcContent] = dr["Content"].ToString();
drNew[dcAttentionCarBrandName] = dr["AttentionCarBrandName"].ToString();
drNew[dcAttentionCarSerialName] = dr["AttentionCarSerialName"].ToString();
drNew[dcAttentionCarTypeName] = dr["AttentionCarTypeName"].ToString();
drNew[dcSelectDealerName] = dr["SelectDealerName"].ToString();
drNew[dcIsReturnVisit] = dr["IsReturnVisit"].ToString() == "-2" ? "" : (dr["IsReturnVisit"].ToString() == "1" ? "是" : "否");
drNew[dcNominateActivity] = dr["NominateActivity"].ToString();
drNew[dcSaleCarBrandName] = dr["SaleCarBrandName"].ToString();
drNew[dcSaleCarSerialName] = dr["SaleCarSerialName"].ToString();
drNew[dcSaleCarTypeName] = dr["SaleCarTypeName"].ToString();
drNew[dcProvincel] = dr["CustProvince"].ToString();
drNew[dcCity] = dr["CustCity"].ToString();
}
else
{
drNew[dcCustName] = dr["CustName"].ToString();
drNew[dcProvincel] = dr["Province"].ToString();
drNew[dcCity] = dr["City"].ToString();
drNew[dcCounty] = dr["Country"].ToString();
drNew[dcContact] = dr["Contact"].ToString();
drNew[dcContactTel] = dr["ContactTel"].ToString();
//增加是否接通和未接通原因
drNew[dcIsEstablish] = BLL.Util.GetIsNotStatus(dr["IsEstablish"].ToString());
string notEstablishReasonName = String.Empty;
string notEstablishReason = dr["NotEstablishReason"].ToString();
if ((!String.IsNullOrEmpty(notEstablishReason) || notEstablishReason.Trim() == "-1" || notEstablishReason.Trim() == "-2"))
{
notEstablishReasonName = BLL.Util.GetEnumOptText(typeof(Entities.NotEstablishReason), Int32.Parse(notEstablishReason));
}
drNew[dcNotEstablishReason] = notEstablishReasonName;
drNew[dcTag] = dr["TagName"].ToString();
drNew[dcType] = dr["IsComplaintType"].ToString() == "True" ? "是" : "否";
drNew[dcPriorityLevel] = dr["PriorityLevel"].ToString() == "1" ? "普通" : "紧急";
drNew[dcLastDate] = dr["LastProcessDate"].ToString();
drNew[dcWorkOrderStatus] = BLL.Util.GetEnumOptText(typeof(Entities.WorkOrderStatus), int.Parse(dr["WorkOrderStatus"].ToString()));
drNew[dcContent] = dr["Content"].ToString();
drNew[dcReceiver] = dr["ReceiverName"].ToString();
drNew[dcReceiverDepartName] = dr["ReceiverDepartName"].ToString();
drNew[dcIsSales] = dr["IsSales"].ToString() == "True" ? "是" : "否";
drNew[dcIsRevert] = dr["IsRevert"].ToString() == "True" ? "是" : "否";
}
//查询大区 强斐 2014-12-17
BitAuto.YanFa.Crm2009.Entities.AreaInfo info = BLL.Util.GetAreaInfoByPCC(
BLL.Util.GetDataRowValue(drNew, dcProvincel.ColumnName),
BLL.Util.GetDataRowValue(drNew, dcCity.ColumnName),
BLL.Util.GetDataRowValue(drNew, dcCounty.ColumnName));
drNew[dcAreaName] = info == null ? "" : info.DistinctName;
drNew[dcLastOptTime] = dr["LastOptTime"].ToString();
drNew[dcCreateUser] = dr["CreateUserName"].ToString();
drNew[dcCreateTime] = dr["CreateTime"].ToString();;
dtNew.Rows.Add(drNew);
}
//BitAuto.ISDC.CC2012.Web.AjaxServers.ExcelOperate.ExcelInOut.CreateEXCEL(dtNew, "工单记录结果表", RequestBrowser);
BLL.Util.ExportToCSV("工单记录结果表", dtNew);
}
protected void Page_Load(object sender, EventArgs e)
{
#region 页面初次加载
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(TaskID))
{
#region 绑定失败理由
BindFailReson();
#endregion
#region 绑定预计购车时间
BindPlanBuyCarTime();
#endregion
#region 任务不为空
int TaskIDInt = 0;
if (int.TryParse(TaskID, out TaskIDInt))
{
#region 任务数据格式正确
Entities.GroupOrderTask model = GroupOrderTask.Instance.GetGroupOrderTask(TaskIDInt);
if (model != null)
{
#region 任务存在
if (model.TaskStatus == (int)Entities.GroupTaskStatus.NoAllocation || model.TaskStatus == (int)Entities.GroupTaskStatus.Processed)
{
#region 任务不处于处理状态
Response.Write(@"<script language='javascript'>alert('当前任务不处于处理状态，页面将被关闭。');try {
window.external.MethodScript('/browsercontrol/closepagereloadppage');
}
catch (e) {
window.opener = null; window.open('', '_self'); window.close();
}</script>");
#endregion
}
else
{
#region 任务处于处理状态
if (model.AssignUserID != BLL.Util.GetLoginUserID())
{
#region 当前人不是处理人
Response.Write(@"<script language='javascript'>alert('您不是该任务的当前处理人，页面将被关闭。');try {
window.external.MethodScript('/browsercontrol/closepagereloadppage');
}
catch (e) {
window.opener = null; window.open('', '_self'); window.close();
}</script>");
#endregion
}
else
{
#region 加载页面
Entities.GroupOrder grouporder = BLL.GroupOrder.Instance.GetGroupOrder(TaskIDInt);
if (grouporder != null)
{
#region 订单存在
//客户名称
CustName = grouporder.CustomerName;
//客户性别
if (grouporder.UserGender == 1)
{
rdoMan.Checked = true;
}
else if (grouporder.UserGender == 2)
{
rdoWomen.Checked = true;
}
//客户电话
CustTel = grouporder.CustomerTel;
//客户城市id
CityID = grouporder.CityID.ToString();
//客户省份ID
ProvinceID = grouporder.ProvinceID.ToString();
//客户省份城市
if (!string.IsNullOrEmpty(grouporder.ProvinceName))
{
LocationName += grouporder.ProvinceName + " ";
}
if (!string.IsNullOrEmpty(grouporder.CityName))
{
LocationName += grouporder.CityName;
}
//大区id
AreaID = grouporder.AreaID.ToString();
UserName = grouporder.UserName;
//大区名称
//强斐 2014-12-17
BitAuto.YanFa.Crm2009.Entities.AreaInfo info = BLL.Util.GetAreaInfoByPCC(
BitAuto.ISDC.CC2012.Entities.CommonFunction.ObjectToString(grouporder.ProvinceID),
BitAuto.ISDC.CC2012.Entities.CommonFunction.ObjectToString(grouporder.CityID), null);
AreaName = info == null ? "" : info.DistinctName;
//订单ID
OrderID = grouporder.OrderID.ToString();
//订单编号
OrderCode = grouporder.OrderCode.ToString();
//经销商id
DealerID = grouporder.DealerID.ToString();
//根据经销商id，取名称
if (!string.IsNullOrEmpty(DealerID) && DealerID != "0" && DealerID != "-2")
{
BitAuto.YanFa.Crm2009.Entities.DMSMember DMSModel = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMemberByMemberCode(DealerID);
if (DMSModel != null)
{
MemberID = DMSModel.ID.ToString();
CustID = DMSModel.CustID;
}
}
//经销商名称
DealerName = grouporder.DealerName;
//车款名称
if (!string.IsNullOrEmpty(grouporder.CarMasterName))
{
CarName += grouporder.CarMasterName;
}
if (!string.IsNullOrEmpty(grouporder.CarSerialName))
{
CarName += "-" + grouporder.CarSerialName;
}
if (!string.IsNullOrEmpty(grouporder.CarName))
{
CarName += "-" + grouporder.CarName;
}
//下单时间
DateTime ordertime = System.DateTime.Now;
if (DateTime.TryParse(grouporder.OrderCreateTime.ToString(), out ordertime))
{
OrderTime = ordertime.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
OrderTime = "";
}
//价格
OrderPrice = grouporder.OrderPrice + "万元";
//是否回访
selReturnVisit.SelectedIndex = selReturnVisit.Items.IndexOf(selReturnVisit.Items.FindByValue(grouporder.IsReturnVisit.ToString()));
Remark = grouporder.CallRecord;
//失败原因
selFailReson.SelectedIndex = selFailReson.Items.IndexOf(selFailReson.Items.FindByValue(grouporder.FailReasonID.ToString()));
//加载意向车型
WantCarBrandID = grouporder.WantCarMasterID.ToString();
WantCarSerialID = grouporder.WantCarSerialID.ToString();
WantCarID = grouporder.WantCarID.ToString();
//预计购车时间
if (grouporder.PlanBuyCarTime != -2)
{
dllPlanBuyCarTime.SelectedIndex = dllPlanBuyCarTime.Items.IndexOf(dllPlanBuyCarTime.Items.FindByValue(grouporder.PlanBuyCarTime.ToString()));
}
#endregion
}
else
{
#region 订单不存在
Response.Write(@"<script language='javascript'>alert('该任务对应订单不存在，页面将被关闭。');try {
window.external.MethodScript('/browsercontrol/closepagereloadppage');
}
catch (e) {
window.opener = null; window.open('', '_self'); window.close();
}</script>");
#endregion
}
#endregion
}
#endregion
}
#endregion
}
else
{
#region 任务不存在
Response.Write(@"<script language='javascript'>alert('任务不存在，页面将被关闭。');try {
window.external.MethodScript('/browsercontrol/closepagereloadppage');
}
catch (e) {
window.opener = null; window.open('', '_self'); window.close();
}</script>");
#endregion
}
#endregion
}
else
{
#region 格式不正确
Response.Write(@"<script language='javascript'>alert('任务的数据格式不正确，页面将被关闭。');try {
window.external.MethodScript('/browsercontrol/closepagereloadppage');
}
catch (e) {
window.opener = null; window.open('', '_self'); window.close();
}</script>");
#endregion
}
#endregion
}
else
{
#region 任务为空
Response.Write(@"<script language='javascript'>alert('任务不能为空，页面将被关闭。');try {
window.external.MethodScript('/browsercontrol/closepagereloadppage');
}
catch (e) {
window.opener = null; window.open('', '_self'); window.close();
}</script>");
#endregion
}
}
#endregion
}
private string[] GetCustInfoDataRow(string PTID, DataRow dr)
{
string[] array_CustDatas = new string[8] {
PTID, "", "", "", "", "", "", ""
};
//获取省 市 区
int proviceID = CommonFunction.ObjectToInteger(dr["ProvinceID"]);
int cityID = CommonFunction.ObjectToInteger(dr["CityID"]);
int CountyID = CommonFunction.ObjectToInteger(dr["CountyID"]);
//获取大区名称
//强斐 2014-12-17
BitAuto.YanFa.Crm2009.Entities.AreaInfo info = BLL.Util.GetAreaInfoByPCC(proviceID.ToString(), cityID.ToString(), CountyID.ToString());
string areaName = info == null ? "" : info.DistinctName;
string provinceName = dr["ProvinceName"].ToString();
string cityName = dr["CityName"].ToString();
string countryName = dr["CountryName"].ToString();
string custName = dr["CustName"].ToString();
string[] MmeberIDs = dr["MemberID"].ToString().Split(',');
//易湃会员
string DMSMemberID = "";
string DMSMemberName = "";
for (int m = 0; m < MmeberIDs.Length; m++)
{
string[] mid = MmeberIDs[m].Split('|');
if (mid.Length == 2)
{
DMSMemberID += mid[0] + ",";
DMSMemberName += mid[1] + ",";
}
}
DMSMemberID = DMSMemberID.TrimEnd(',');
DMSMemberName = DMSMemberName.TrimEnd(',');
//车商通会员
string[] cstMmeberIDs = dr["CstMemberID"].ToString().Split(',');
string cstMemberID = "";
string cstMemberName = "";
for (int m = 0; m < cstMmeberIDs.Length; m++)
{
string[] mid = cstMmeberIDs[m].Split('|');
if (mid.Length == 2)
{
cstMemberID += mid[0] + ",";
cstMemberName += mid[1] + ",";
}
}
cstMemberID = cstMemberID.TrimEnd(',');
cstMemberName = cstMemberName.TrimEnd(',');
DMSMemberID += ("," + cstMemberID).TrimEnd(',');
DMSMemberName += ("," + cstMemberName).TrimEnd(',');
array_CustDatas = new string[8] {
PTID, custName, provinceName, cityName, countryName, areaName, DMSMemberID, DMSMemberName
};
return(array_CustDatas);
}
