/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_CSTMember model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@OriginalCSTRecID", SqlDbType.VarChar, 10),
new SqlParameter("@VendorCode", SqlDbType.NVarChar, 50),
new SqlParameter("@FullName", SqlDbType.NVarChar, 200),
new SqlParameter("@ShortName", SqlDbType.NVarChar, 50),
new SqlParameter("@VendorClass", SqlDbType.Int, 4),
new SqlParameter("@SuperId", SqlDbType.Int, 4),
new SqlParameter("@ProvinceID", SqlDbType.NVarChar, 20),
new SqlParameter("@CityID", SqlDbType.NVarChar, 20),
new SqlParameter("@CountyID", SqlDbType.VarChar, 20),
new SqlParameter("@Address", SqlDbType.VarChar, 300),
new SqlParameter("@PostCode", SqlDbType.Char, 6),
new SqlParameter("@TrafficInfo", SqlDbType.VarChar, 1024)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.OriginalCSTRecID;
parameters[2].Value = model.VendorCode;
parameters[3].Value = model.FullName;
parameters[4].Value = model.ShortName;
parameters[5].Value = model.VendorClass;
parameters[6].Value = model.SuperId;
parameters[7].Value = model.ProvinceID;
parameters[8].Value = model.CityID;
parameters[9].Value = model.CountyID;
parameters[10].Value = model.Address;
parameters[11].Value = model.PostCode;
parameters[12].Value = model.TrafficInfo;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTMEMBER_UPDATE, parameters));
}
public string CstMemberID()
{
Entities.ProjectTask_CSTMember info = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberModel(this.MemberID);
if (info != null)
{
return(BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.SelectCstMemberIDByCSTRecID(info.OriginalCSTRecID));
}
return(string.Empty);
}
public void ProjectTask_CSTMemberDelete(int memberId)
{
Entities.ProjectTask_CSTMember c = this.GetProjectTask_CSTMember(memberId);
if (c == null)
{
throw new Exception("无法得到此会员");
}
Dal.ProjectTask_CSTMember.Instance.Delete(memberId);
}
/// <summary>
/// 已有的会员
/// </summary>
public UCEditCstMember(Entities.ProjectTask_CSTMember member)
: this()
{
this.Member = member;
this.TaskID = member.PTID;
this.MemberID = member.ID;
if (!string.IsNullOrEmpty(member.VendorCode))
{
}
this.OriginalDMSMemberID = string.IsNullOrEmpty(member.OriginalCSTRecID) ? "" : member.OriginalCSTRecID;
this.ControlName = "车商通会员(" + member.FullName + ")";
}
/// <summary>
/// 根据任务编号查询车商通会员信息
/// </summary>
/// <param name="TID"></param>
/// <returns></returns>
public List <Entities.ProjectTask_CSTMember> GetProjectTask_CSTMemberByTID(string TID)
{
List <Entities.ProjectTask_CSTMember> list = new List <Entities.ProjectTask_CSTMember>();
string sqlStr = "SELECT * FROM ProjectTask_CSTMember WHERE status=0 and PTID='" + StringHelper.SqlFilter(TID) + "'";
DataSet ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.Text, sqlStr);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Entities.ProjectTask_CSTMember cstMember = new Entities.ProjectTask_CSTMember();
cstMember = LoadSingleProjectTask_CSTMember(dr);
list.Add(cstMember);
}
return(list);
}
/// <summary>
/// 删除一条数据
/// </summary>
public int Delete(int ID)
{
Entities.ProjectTask_CSTMember c = this.GetProjectTask_CSTMember(ID);
if (c == null)
{
throw new Exception("无法得到此会员");
}
if (c.OriginalCSTRecID != null)
{
throw new Exception("不可删除CRM中已有的会员");
}
Dal.ProjectTask_CSTMember_Brand.Instance.Delete(ID);
Dal.ProjectTask_CSTLinkMan.Instance.DeleteByCstMemberID(ID);
return(Dal.ProjectTask_CSTMember.Instance.Delete(ID));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetProductOpenKey();
Entities.ProjectTask_CSTMember info = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberModel(this.MemberID);
if (info != null)
{
string cstRecId = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.SelectCstMemberIDByCSTRecID(info.OriginalCSTRecID);
int recId = -1;
if (int.TryParse(cstRecId, out recId))
{
BitAuto.YanFa.Crm2009.Entities.CstMember cstMemberInfo = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCstMemberModel(info.OriginalCSTRecID);
OriginalCstMemberID = cstMemberInfo.CSTRecID;
this.syncTime = cstMemberInfo.SyncTime.ToShortDateString();
}
BitAuto.YanFa.Crm2009.Entities.CSTExpandInfo dstCSTExpandInfo = BitAuto.YanFa.Crm2009.BLL.CSTExpandInfo.Instance.GetModelByCSTRecID(info.OriginalCSTRecID);
if (dstCSTExpandInfo != null)
{
if (dstCSTExpandInfo.UCount != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE)
{
this.UCount = dstCSTExpandInfo.UCount.ToString();
}
if (dstCSTExpandInfo.LastAddUbTime != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.DATE_INVALID_VALUE)
{
this.lastAddUbTime = dstCSTExpandInfo.LastAddUbTime.ToShortDateString();
}
if (dstCSTExpandInfo.UBTotalAmount != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE)
{
this.UbTotalAmount = dstCSTExpandInfo.UBTotalAmount.ToString();
}
if (dstCSTExpandInfo.UBTotalExpend != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.INT_INVALID_VALUE)
{
this.UbTotalExpend = dstCSTExpandInfo.UBTotalExpend.ToString();
}
if (dstCSTExpandInfo.ActiveTime != BitAuto.YanFa.Crm2009.Entities.Constants.Constant.DATE_INVALID_VALUE)
{
this.activeTime = dstCSTExpandInfo.ActiveTime.ToShortDateString();
}
}
}
}
}
/// <summary>
/// 查询是否是已开通的会员
/// </summary>
/// <param name="memberId"></param>
/// <returns></returns>
public bool IsOpenSuccessMember(int memberId)
{
bool isSuccessOpen = false;
//查询是否是开通的会员
Entities.ProjectTask_CSTMember cstMember = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMember(memberId);
if (!string.IsNullOrEmpty(cstMember.OriginalCSTRecID))
{
BitAuto.YanFa.Crm2009.Entities.CstMember cstMemberInfo = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCstMemberModel(cstMember.OriginalCSTRecID);
if (cstMemberInfo != null)
{
if (cstMemberInfo.SyncStatus == (int)BitAuto.YanFa.Crm2009.Entities.EnumCSTSyncStatus.CreateSuccessful)
{
isSuccessOpen = true;
}
}
}
return(isSuccessOpen);
}
private void ShowNameHistory(string memberId)
{
int id = -1;
if (int.TryParse(memberId, out id))
{
Entities.ProjectTask_CSTMember info = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberModel(id);
if (info != null)
{
if (!string.IsNullOrEmpty(info.OriginalCSTRecID))
{
BitAuto.YanFa.Crm2009.Entities.CstMember cstMemberInfo = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCstMemberModel(info.OriginalCSTRecID);
if (cstMemberInfo != null)
{
spanCustID.InnerText = "车商通会编号：" + cstMemberInfo.CstMemberID;
}
repterCustNameHistoryList.DataSource = BLL.ProjectTask_CSTMember.Instance.GetCstMemberFullNameHistory(info.OriginalCSTRecID);
repterCustNameHistoryList.DataBind();
}
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.ProjectTask_CSTMember model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@VendorCode", SqlDbType.NVarChar, 50),
new SqlParameter("@FullName", SqlDbType.NVarChar, 200),
new SqlParameter("@ShortName", SqlDbType.NVarChar, 50),
new SqlParameter("@VendorClass", SqlDbType.Int, 4),
new SqlParameter("@SuperId", SqlDbType.Int, 4),
new SqlParameter("@ProvinceID", SqlDbType.NVarChar, 20),
new SqlParameter("@CityID", SqlDbType.NVarChar, 20),
new SqlParameter("@CountyID", SqlDbType.VarChar, 20),
new SqlParameter("@Address", SqlDbType.VarChar, 300),
new SqlParameter("@PostCode", SqlDbType.Char, 6),
new SqlParameter("@TrafficInfo", SqlDbType.VarChar, 1024),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.PTID;
parameters[2].Value = model.VendorCode;
parameters[3].Value = model.FullName;
parameters[4].Value = model.ShortName;
parameters[5].Value = model.VendorClass;
parameters[6].Value = model.SuperId;
parameters[7].Value = model.ProvinceID;
parameters[8].Value = model.CityID;
parameters[9].Value = model.CountyID;
parameters[10].Value = model.Address;
parameters[11].Value = model.PostCode;
parameters[12].Value = model.TrafficInfo;
parameters[13].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTMEMBER_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 从CC_Custs中读取客户信息与会员信息。
/// </summary>
private void LoadInfoFromCC_Cust(Entities.ProjectTaskInfo task)
{
#region 加载客户信息
Entities.ProjectTask_Cust ccCust = BLL.ProjectTask_Cust.Instance.GetProjectTask_Cust(task.PTID);
CarType = ccCust.CarType.ToString();
this.OriginalCustID = ccCust.OriginalCustID;
this.tfCustName.Value = ccCust.CustName;
this.tfCustAbbr.Value = ccCust.AbbrName;
ListItem li = this.selCustType.Items.FindByValue(ccCust.TypeID);
this.selCustType.SelectedIndex = this.selCustType.Items.IndexOf(li);
//如果客户类型为特许经销商，显示所属4S
if (ccCust.TypeID == Convert.ToString((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Licence))
{
//lbl4S.Style["display"] = "blank";
}
if (task.Source == 2) //CRM库来源
{
selCustType.Attributes.Add("disabled", "disabled"); //不能编辑客户类别
}
li = this.selCustIndustry.Items.FindByValue(ccCust.IndustryID);
this.selCustIndustry.SelectedIndex = this.selCustIndustry.Items.IndexOf(li);
this.InitialProvinceID = ccCust.ProvinceID;
this.InitialCityID = ccCust.CityID;
this.InitialCountyID = ccCust.CountyID;
this.tfAddress.Value = ccCust.Address;
this.tfZipcode.Value = ccCust.Zipcode;
if (!string.IsNullOrEmpty(ccCust.TradeMarketID))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.TradeMarketID.ToString());
if (custInfo != null)
{
tfCustPidName1.Value = custInfo.CustName;
tfCustPid1.Value = ccCust.TradeMarketID.ToString();
}
}
#region Modify=masj，Date=2012-04-13 注释掉
//if (ccCust.CstMemberID != "" && ccCust.CstMemberID != null)
//{
// this.txtCtsMemberID.Value = ccCust.CstMemberID;
//}
#endregion
if (ccCust.CarType == 3)
{
this.chkOldCarType.Checked = true;
if (!string.IsNullOrEmpty(ccCust.UsedCarBusinessType))
{
this.sltUsedCarBusinessType.Value = ccCust.UsedCarBusinessType.ToString();
}
if (!string.IsNullOrEmpty(ccCust.TradeMarketID))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.TradeMarketID.ToString());
if (custInfo != null)
{
tfCustPidName1.Value = custInfo.CustName;
tfCustPid1.Value = ccCust.TradeMarketID.ToString();
}
}
}
if (!string.IsNullOrEmpty(ccCust.OriginalCustID))
{
if (ccCust.Status != null)
{
switch (ccCust.Status.Value)
{
case 0:
imgCustStatus.Src = "/Images/xt.gif";
imgCustStatus.Attributes.Add("title", "在用");
break;
case 1:
imgCustStatus.Src = "/Images/xt_1.gif";
imgCustStatus.Attributes.Add("title", "停用");
break;
default:
break;
}
}
if (ccCust.Lock != null && ccCust.Lock.Value == 1)
{
imgCustStatusLock.Src = "/Images/lock.gif";
imgCustStatusLock.Attributes.Add("title", "锁定");
}
else if (ccCust.Lock != null && ccCust.Lock.Value == 0)
{
imgCustStatusLock.Src = "/Images/unlock.gif";
imgCustStatusLock.Attributes.Add("title", "未锁定");
}
liCustStatus.Style.Remove("display");
liCustLock.Style.Remove("display");
}
li = this.selCustLevel.Items.FindByValue(ccCust.LevelID);
this.selCustLevel.SelectedIndex = this.selCustLevel.Items.IndexOf(li);
BitAuto.YanFa.Crm2009.Entities.CustInfo crmCust = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.CustPid);
if (crmCust != null)
{
this.tfCustPid.Value = crmCust.CustID; this.tfCustPidName.Value = crmCust.CustName;
}
crmCust = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.Pid);
if (crmCust != null)
{
this.tfPid.Value = crmCust.CustID; this.tfPidName.Value = crmCust.CustName;
}
crmCust = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.FoursPid);
if (crmCust != null)
{
this.tf4sPid.Value = crmCust.CustID; this.tf4sName.Value = crmCust.CustName;
}
li = this.selShopLevel.Items.FindByValue(ccCust.ShopLevel);
this.selShopLevel.SelectedIndex = this.selShopLevel.Items.IndexOf(li);
this.tfBrand.Value = BLL.Util.List2String(ccCust.BrandIDs, ",", "", "");
this.tfBrandName.Value = BLL.Util.List2String(ccCust.BrandNames, ",", "", "");
this.tfOfficeTel.Value = ccCust.OfficeTel;
this.tfFax.Value = ccCust.Fax;
this.tfContactName.Value = ccCust.ContactName;
this.tfNotes.Value = ccCust.Notes;
#endregion
#region 加载会员信息(如果没有会员，并且从excel中加载，加载一个空会员控件)
List <Entities.ProjectTask_DMSMember> ccMembers = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMemberByTID(task.PTID);
if (ccMembers.Count > 0)
{
Control ctl;
foreach (Entities.ProjectTask_DMSMember m in ccMembers)
{
//在CRM中有会员
if (string.IsNullOrEmpty(m.OriginalDMSMemberID) == false)
{
HasMembersInCrm = true;
}
ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditMember.ascx", m);
this.PlaceHolder.Controls.Add(ctl);
}
}
else
{
if (task.Source == 1)
{
Control ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditMember.ascx", task.PTID);
this.PlaceHolder.Controls.Add(ctl);
}
}
#endregion
#region 加载车商通会员信息
//如果是新车二手车或二手车
if (ccCust.CarType == 2 || ccCust.CarType == 3)
{
Entities.ProjectTask_CSTMember queryCstMember = new Entities.ProjectTask_CSTMember();
List <Entities.ProjectTask_CSTMember> ccCstMembers = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(task.PTID);
if (ccCstMembers.Count > 0)
{
Control ctl;
foreach (Entities.ProjectTask_CSTMember m in ccCstMembers)
{
////在CRM中有会员
//if (string.IsNullOrEmpty(m.OriginalDMSMemberID) == false) { HasMembersInCrm = true; }
ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditCstMember.ascx", m);
this.PlaceHolderCstMember.Controls.Add(ctl);
}
}
}
//如果是新车客户，显示车商通的会员
if (ccCust.CarType == 1)
{
List <Entities.ProjectTask_CSTMember> ccMemberList = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(this.Task.PTID);
Control ctl;
foreach (Entities.ProjectTask_CSTMember m in ccMemberList)
{
ctl = this.LoadControl("~/CustInfo/DetailV/UCCstMemberFromCC.ascx", m);
this.PlaceHolderShowCstMember.Controls.Add(ctl);
}
}
#endregion
}
//private void BindQuestionnaireInfo()
//{
// repeaterQ.DataSource = BLL.CC_Questionnaire.Instance.GetCC_Questionnaire(string.Empty, "CreateTime");
// repeaterQ.DataBind();
//}
//protected void repeaterQ_ItemDataBound(Object Sender, RepeaterItemEventArgs e)
//{
// if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
// {
// int qustID = int.Parse(DataBinder.Eval(e.Item.DataItem, "QustID").ToString().Trim());
// Repeater rOpt = e.Item.FindControl("repeaterOpt") as Repeater;
// rOpt.DataSource = BLL.CC_QuestionnairOption.Instance.GetCC_QuestionnairOption(" QustID=" + qustID, "CreateTime");
// rOpt.DataBind();
// }
//}
//protected string IsCheck(string custId, string optId)
//{
// string result = string.Empty;
// Entities.CC_TaskQuestionnaire taskQ = BLL.CC_TaskQuestionnaire.Instance.GetCC_TaskQuestionnaire(OriginalDMSMemberID, int.Parse(custId), 1);
// if (taskQ != null)
// {
// if (taskQ.QustOptID == int.Parse(optId))
// {
// result = "checked=true;";
// }
// }
// return result;
//}
//protected string GetQustDescript( string custId)
//{
// string result = string.Empty;
// Entities.CC_TaskQuestionnaire taskQ = BLL.CC_TaskQuestionnaire.Instance.GetCC_TaskQuestionnaire(OriginalDMSMemberID, int.Parse(custId), 1);
// if (taskQ != null)
// {
// result = taskQ.Description;
// }
// return result;
//}
#endregion
private void LoadMemberInfo()
{
Control ctl;
Control ct2;
int memberId = -1;
if (int.TryParse(MemberID, out memberId))
{
//车易通
Entities.ProjectTask_DMSMember m = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMember(memberId);
//4-19 正式测试注释去掉
if (m != null)
{
if (m.Status != -1)
{
OriginalDMSMemberID = m.OriginalDMSMemberID;
if (OriginalDMSMemberID != "")
{
BitAuto.YanFa.Crm2009.Entities.DMSMember dmsM = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMember(new Guid(m.OriginalDMSMemberID));
if (dmsM != null)
{
if (dmsM.SyncStatus != (int)BitAuto.YanFa.Crm2009.Entities.EnumDMSSyncStatus.Rejected)
{
btnDisplay = "style='display:none;'";
ctl = this.LoadControl("~/CustInfo/DetailV/UCMember.ascx", m);
}
else
{
btnDisplay = "style='display:block;'";
ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditMember.ascx", m);
}
this.PlaceHolder.Controls.Add(ctl);
}
else
{
btnDisplay = "style='display:none;'";
}
}
}
}
//车商通
Entities.ProjectTask_CSTMember mcst = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMember(memberId);
if (mcst != null)
{
if (mcst.Status != -1)
{
OriginalCSTRecID = mcst.OriginalCSTRecID;
if (OriginalCSTRecID != "")
{
BitAuto.YanFa.Crm2009.Entities.CstMember cstM = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCSTMember(OriginalCSTRecID);
if (cstM != null)
{
if (cstM.SyncStatus != (int)BitAuto.YanFa.Crm2009.Entities.EnumCSTSyncStatus.Rejected)
{
btnDisplay = "style='display:none;'";
ct2 = this.LoadControl("~/CustInfo/DetailV/UCCstMember.ascx", cstM);
}
else
{
btnDisplay = "style='display:block;'";
ct2 = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditSndCstMember.ascx", cstM);
}
this.CSTPlaceHolder.Controls.Add(ct2);
}
else
{
btnDisplay = "style='display:none;'";
}
}
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_CSTMember model)
{
return(Dal.ProjectTask_CSTMember.Instance.Update(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateCstMember(Entities.ProjectTask_CSTMember model)
{
Dal.ProjectTask_CSTMember_Brand.Instance.Delete(model.ID);
Dal.ProjectTask_CSTLinkMan.Instance.DeleteByCstMemberID(model.ID);
return(Dal.ProjectTask_CSTMember.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.ProjectTask_CSTMember model)
{
return(Dal.ProjectTask_CSTMember.Instance.Insert(model));
}
public UCCstMemberFromCC(Entities.ProjectTask_CSTMember member)
: this()
{
this.Member = member;
this.ControlName = "车商通会员(" + Member.FullName + ")";
}
private void BindData()
{
//把对象信息存入页面变量中
Entities.ProjectTask_CSTMember cstMember = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberModel(this.Member.ID);
if (cstMember != null)
{
vendorClass = cstMember.VendorClass.ToString();
if (cstMember.OriginalCSTRecID != null)
{
BitAuto.YanFa.Crm2009.Entities.CstMember info = BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.GetCSTMember(cstMember.OriginalCSTRecID);
if (info != null)
{
SyncStatusValue = info.SyncStatus.ToString();
CSTMemberID = info.CstMemberID.ToString();
}
if (BLL.ProjectTask_CSTMember.Instance.IsOpenSuccessMember(this.Member.ID))
{
//是否有名称变更
DataTable dtFullName = BLL.ProjectTask_AuditContrastInfo.Instance.GetProjectTask_AuditContrastInfo(cstMember.OriginalCSTRecID, 7, "FullName");
if (dtFullName.Rows.Count > 0)
{
FullNameHavHistory = true;
}
}
}
this.clientFullName = cstMember.FullName;
this.clientShortName = cstMember.ShortName;
this.clientCode = cstMember.VendorCode;
this.clientType = GetCstTypeString((int)cstMember.VendorClass);
this.upCompanyName = GetSuperCompanyString((int)cstMember.SuperId);
this.region = GetRegionString(cstMember.ProvinceID, cstMember.CityID, cstMember.CountyID);
this.detailAddr = cstMember.Address;
this.postCode = cstMember.PostCode;
this.TrafficInfo = cstMember.TrafficInfo;
//主营品牌
List <Entities.ProjectTask_CSTMember_Brand> listCstMember = BLL.ProjectTask_CSTMember_Brand.Instance.GetProjectTask_CSTMember_Brand(Member.ID);
if (listCstMember != null)
{
string BrandIds = "";
foreach (Entities.ProjectTask_CSTMember_Brand cstMemberBrand in listCstMember)
{
BrandIds += cstMemberBrand.BrandID + ",";
}
BrandIds = BrandIds.TrimEnd(',');
BrandIdsName = BitAuto.YanFa.Crm2009.BLL.CarBrand.Instance.GetBrandNames(BrandIds);
}
//联系人
Entities.ProjectTask_CSTLinkMan linkManInfo = BLL.ProjectTask_CSTLinkMan.Instance.GetProjectTask_CSTLinkManModel(cstMember.ID);
if (linkManInfo != null)
{
this.contact = linkManInfo.Name;
this.depart = linkManInfo.Department;
this.position = linkManInfo.Position;
this.phone = linkManInfo.Mobile;
this.email = linkManInfo.Email;
}
//车商币信息
if (Member.OriginalCSTRecID != null)
{
BitAuto.YanFa.Crm2009.Entities.CSTExpandInfo dstCSTExpandInfo = BitAuto.YanFa.Crm2009.BLL.CSTExpandInfo.Instance.GetModelByCSTRecID(Member.OriginalCSTRecID);
if (dstCSTExpandInfo != null)
{
if (dstCSTExpandInfo.UCount != Constant.INT_INVALID_VALUE)
{
this.UCount = dstCSTExpandInfo.UCount.ToString();
}
if (dstCSTExpandInfo.LastAddUbTime != Constant.DATE_INVALID_VALUE)
{
this.lastAddUbTime = dstCSTExpandInfo.LastAddUbTime.ToShortDateString();
}
if (dstCSTExpandInfo.UBTotalAmount != Constant.INT_INVALID_VALUE)
{
this.UbTotalAmount = dstCSTExpandInfo.UBTotalAmount.ToString();
}
if (dstCSTExpandInfo.UBTotalExpend != Constant.INT_INVALID_VALUE)
{
this.UbTotalExpend = dstCSTExpandInfo.UBTotalExpend.ToString();
}
if (dstCSTExpandInfo.ActiveTime != Constant.DATE_INVALID_VALUE)
{
this.activeTime = dstCSTExpandInfo.ActiveTime.ToShortDateString();
}
}
}
}
}
public void Validate(bool whenSubmit, out Entities.ProjectTask_Cust cust, out List <Entities.ProjectTask_CSTMember> cstMembers, out List <Entities.ProjectTask_CSTLinkMan> cstLinkMans, out List <string> cstMemberBrandsArry)//save or submit
{
Regex reMemberPhoneAndFax = new Regex(@"(^0[0-9]{2,3}-[0-9]{7,8}$)|(^0[0-9]{2,3}-[0-9]{7,8}-[0-9]{1,5}$)|(^13[0-9]{9}$)|(^15[0-9]{9}$)|(^18[0-9]{9}$)|(^400\d{7}$)");
int i = -1;
#region 客户信息验证
if (CustInfo == null)
{
throw new Exception("必须要有客户信息");
}
if (string.IsNullOrEmpty(CustInfo.TID))
{
throw new Exception("TID不可为空");
}
cust = BLL.ProjectTask_Cust.Instance.GetProjectTask_Cust(CustInfo.TID);
if (cust == null)
{
throw new Exception("找不到此客户的核对信息");
}
if (string.IsNullOrEmpty(CustInfo.CustName))
{
throw new Exception("客户名称不可为空");
}
if (CustInfo.CustName.Length > 50)
{
throw new Exception("客户名称超长");
}
cust.CustName = CustInfo.CustName;
if (CustInfo.CustAbbr.Length > 50)
{
throw new Exception("客户简称超长");
}
cust.AbbrName = CustInfo.CustAbbr;
if (string.IsNullOrEmpty(CustInfo.LevelID) == false && int.TryParse(CustInfo.LevelID, out i) == false)
{
throw new Exception("LevelID无法转换成int类型");
}
cust.LevelID = CustInfo.LevelID;
if (string.IsNullOrEmpty(CustInfo.IndustryID) == false && int.TryParse(CustInfo.IndustryID, out i) == false)
{
throw new Exception("IndustryID无法转换成int类型");
}
if (whenSubmit && i <= 0)
{
throw new Exception("客户行业必填");
}
cust.IndustryID = CustInfo.IndustryID;
if (string.IsNullOrEmpty(CustInfo.TypeID) == false && int.TryParse(CustInfo.TypeID, out i) == false)
{
throw new Exception("TypeID无法转换成int类型");
}
if (whenSubmit && i <= 0)
{
throw new Exception("客户类别必填");
}
cust.TypeID = CustInfo.TypeID;
if (string.IsNullOrEmpty(CustInfo.ShopLevel) == false && int.TryParse(CustInfo.ShopLevel, out i) == false)
{
throw new Exception("ShopLevel无法转换成int类型");
}
cust.ShopLevel = CustInfo.ShopLevel;
if (string.IsNullOrEmpty(CustInfo.ProvinceID) == false && int.TryParse(CustInfo.ProvinceID, out i) == false)
{
throw new Exception("ProvinceID无法转换成int类型");
}
if (whenSubmit && i <= 0)
{
throw new Exception("客户省份必填");
}
cust.ProvinceID = CustInfo.ProvinceID;
if (string.IsNullOrEmpty(CustInfo.CityID) == false && int.TryParse(CustInfo.CityID, out i) == false)
{
throw new Exception("CityID无法转换成int类型");
}
if (whenSubmit && i <= 0)
{
throw new Exception("客户城市必填");
}
cust.CityID = CustInfo.CityID;
if (string.IsNullOrEmpty(CustInfo.CountyID) == false && int.TryParse(CustInfo.CountyID, out i) == false)
{
throw new Exception("CountyID无法转换成int类型");
}
if (CustInfo.IsHasCounty.Equals("0"))
{
if (whenSubmit && i <= 0)
{
throw new Exception("客户区县必填");
}
}
cust.CountyID = CustInfo.CountyID;
if (CustInfo.Address.Length > 400)
{
throw new Exception("客户地址超长");
}
if (whenSubmit && string.IsNullOrEmpty(CustInfo.Address))
{
throw new Exception("客户地址必填");
}
cust.Address = CustInfo.Address;
if (CustInfo.Zipcode.Length > 10)
{
throw new Exception("客户邮编超长");
}
if (whenSubmit && string.IsNullOrEmpty(CustInfo.Zipcode))
{
throw new Exception("客户邮编必填");
}
cust.Zipcode = CustInfo.Zipcode;
if (CustInfo.OfficeTel.Length > 50)
{
throw new Exception("客户电话超长");
}
cust.OfficeTel = CustInfo.OfficeTel;
if (CustInfo.Fax.Length > 50)
{
throw new Exception("客户传真超长");
}
cust.Fax = CustInfo.Fax;
if (CustInfo.Notes.Length > 2000)
{
throw new Exception("客户备注超长");
}
cust.Notes = CustInfo.Notes;
if (CustInfo.ContactName.Length > 50)
{
throw new Exception("客户联系人超长");
}
cust.ContactName = CustInfo.ContactName;
int carType = -1;
if (CustInfo.CarType == "1,2")
{
cust.CarType = 3;
int usedCarBusinessType = -1;
if (!int.TryParse(CustInfo.UsedCarBusinessType, out usedCarBusinessType))
{
throw new Exception("请选择二手车经营范围！");
}
else
{
if (usedCarBusinessType > 0)
{
cust.UsedCarBusinessType = usedCarBusinessType.ToString();
}
else
{
throw new Exception("请选择二手车经营范围！");
}
}
if (!string.IsNullOrEmpty(CustInfo.TradeMarketID))
{
int tradeMarketId = -1;
if (int.TryParse(CustInfo.TradeMarketID, out tradeMarketId))
{
if (tradeMarketId > 0)
{
cust.TradeMarketID = tradeMarketId.ToString();
}
}
}
}
else if (int.TryParse(CustInfo.CarType, out carType))
{
cust.CarType = carType;
if (carType == 2)
{
int usedCarBusinessType = -1;
if (int.TryParse(CustInfo.UsedCarBusinessType, out usedCarBusinessType))
{
cust.UsedCarBusinessType = usedCarBusinessType.ToString();
}
int tradeMarketId = -1;
if (int.TryParse(CustInfo.TradeMarketID, out tradeMarketId))
{
if (tradeMarketId > 0)
{
cust.TradeMarketID = tradeMarketId.ToString();
}
}
}
}
else
{
throw new Exception("请选择经营范围！");
}
#region Modify=masj，Date=2012-04-13 注释掉
//CustInfo.CarType
if (!string.IsNullOrEmpty(CustInfo.CtsMemberID))
{
//int ctsMemberID = -1;
//if (int.TryParse(CustInfo.CtsMemberID, out ctsMemberID))
//{
// if (ctsMemberID > 0)
// {
if (CustInfo.CtsMemberID.Length > 50)
{
throw new Exception("车商通会员ID超长");
}
cust.CstMemberID = HttpUtility.UrlDecode(CustInfo.CtsMemberID);
// }
// else
// {
// throw new Exception("车商通会员ID必须是正整数！");
// }
//}
//else
//{
// throw new Exception("车商通会员ID必须是数字");
//}
}
#endregion
#endregion
cstMembers = new List <Entities.ProjectTask_CSTMember>();
cstLinkMans = new List <Entities.ProjectTask_CSTLinkMan>();
cstMemberBrandsArry = new List <string>();
#region 车商通会员信息验证
if (cust.CarType != 1)
{
Hashtable htMemberName = new Hashtable();
Hashtable htMemberAbbr = new Hashtable();
Hashtable htVendorCode = new Hashtable();
foreach (CheckedCstMemberInfo m in this.CstMemberInfoArray)
{
Entities.ProjectTask_CSTMember cstMemberInfo = null;
if (string.IsNullOrEmpty(m.MemberID))
{
cstMemberInfo = new Entities.ProjectTask_CSTMember();
}
else
{
int memberId = -1;
if (int.TryParse(m.MemberID, out memberId))
{
cstMemberInfo = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMember(memberId);
}
}
cstMemberInfo.Address = m.Address;
int tempId = -1;
if (!int.TryParse(m.CityID, out tempId) && whenSubmit)
{
throw new Exception(m.MemberName + ",请选择会员地区！");
}
cstMemberInfo.CityID = m.CityID;
cstMemberInfo.CountyID = m.CountyID;
cstMemberInfo.CreateTime = DateTime.Now;
cstMemberInfo.CreateUserID = BLL.Util.GetLoginUserID();
if (int.TryParse(m.MemberID, out tempId))
{
cstMemberInfo.ID = int.Parse(m.MemberID);
}
if (whenSubmit)
{
if (!htMemberName.Contains(m.MemberName))
{
htMemberName.Add(m.MemberName, m.MemberName);
}
else
{
throw new Exception("同一客户下，不能存在相同名称的车商通会员");
}
if (m.MemberName.Length == 0)
{
throw new Exception(m.MemberName + ",会员名称不能为空！");
}
else if (m.MemberName.Length > 25)
{
throw new Exception(m.MemberName + ",会员名称不能超过25个汉字！");
}
#region 12.11.7 车商通会员全称可以重复 lxw 去掉车商通会员全称查重
//else
//{
// if (int.TryParse(m.MemberID, out tempId))
// {
// Entities.ProjectTask_CSTMember memberInfo = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMember(tempId);
// //yyh是否存在重名的会员名称
// if (!string.IsNullOrEmpty(memberInfo.OriginalCSTRecID))
// {
// string where = " FullName='" + Utils.StringHelper.SqlFilter(m.MemberName) + "' and CSTRecID!='" + memberInfo.OriginalCSTRecID + "'";
// if (Crm2009.BLL.CstMember.Instance.ExistsCstMember(where) > 0)
// {
// throw new Exception(m.MemberName + ",有重名的会员名称！");
// }
// }
// else
// {
// string where = " AND FullName='" + Utils.StringHelper.SqlFilter(m.MemberName) + "' and Status=0 and ID != " + tempId;
// if (BLL.ProjectTask_CSTMember.Instance.IsExistSameName(where) == true)
// {
// throw new Exception(m.MemberName + ",cc有重名的会员名称！");
// }
// //string where = " FullName='" + Utils.StringHelper.SqlFilter(m.MemberName) + "'";
// //if (Crm2009.BLL.CstMember.Instance.ExistsCstMember(where) > 0)
// //{
// // throw new Exception(m.MemberName + ",有重名的会员名称！");
// //}
// }
// }
// else
// {
// string where = " AND FullName='" + Utils.StringHelper.SqlFilter(m.MemberName) + "' and Status=0 and ID != " + tempId;
// if (BLL.ProjectTask_CSTMember.Instance.IsExistSameName(where) == true)
// {
// throw new Exception(m.MemberName + ",cc有重名的会员名称！");
// }
// //string where = " FullName='" + Utils.StringHelper.SqlFilter(m.MemberName) + "'";
// //if (Crm2009.BLL.CstMember.Instance.ExistsCstMember(where) > 0)
// //{
// // throw new Exception(m.MemberName + ",有重名的会员名称33！");
// //}
// }
//}
#endregion
}
cstMemberInfo.FullName = m.MemberName;
if (whenSubmit)
{
if (!htMemberAbbr.Contains(m.MemberAbbr))
{
htMemberAbbr.Add(m.MemberAbbr, m.MemberAbbr);
}
else
{
throw new Exception("同一客户下，不能存在相同简称的车商通会员");
}
if (m.MemberAbbr.Length == 0)
{
throw new Exception(m.MemberName + ",会员简称不能为空！");
}
else if (m.MemberAbbr.Length > 16)//Modify=Masj,Date=2012-08-28
{
throw new Exception(m.MemberName + ",会员简称不能超过16个字符！");
}
else
{
if (int.TryParse(m.MemberID, out tempId))
{
Entities.ProjectTask_CSTMember memberInfo = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMember(tempId);
//是否存在重名的会员简称
if (!string.IsNullOrEmpty(memberInfo.OriginalCSTRecID))
{
string where = " ShortName='" + Utils.StringHelper.SqlFilter(m.MemberAbbr) + "' and CSTRecID!='" + memberInfo.OriginalCSTRecID + "'";
if (BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.ExistsCstMember(where) > 0)
{
throw new Exception(m.MemberAbbr + ",crm库有重名的会员简称！");
}
}
else
{
//12.6.8 lxw cc查重
string where = " AND ShortName='" + Utils.StringHelper.SqlFilter(m.MemberAbbr) + "' and Status=0 and ID != " + tempId;
if (BLL.ProjectTask_CSTMember.Instance.IsExistSameName(where) == true)
{
throw new Exception(m.MemberName + ",cc库有重名的会员简称！");
}
//12.11.7 crm查重
string where1 = " ShortName='" + Utils.StringHelper.SqlFilter(m.MemberAbbr) + "'";
if (BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.ExistsCstMember(where1) > 0)
{
throw new Exception(m.MemberAbbr + ",crm库有重名的会员简称！");
}
}
}
else
{
//12.6.8 lxw cc查重
string where = " AND ShortName='" + Utils.StringHelper.SqlFilter(m.MemberAbbr) + "' and Status=0 and ID != " + tempId;
if (BLL.ProjectTask_CSTMember.Instance.IsExistSameName(where) == true)
{
throw new Exception(m.MemberName + ",cc库有重名的会员简称！");
}
//12.11.7 crm查重
string where1 = " ShortName='" + Utils.StringHelper.SqlFilter(m.MemberAbbr) + "'";
if (BitAuto.YanFa.Crm2009.BLL.CstMember.Instance.ExistsCstMember(where1) > 0)
{
throw new Exception(m.MemberAbbr + ",crm库有重名的会员简称！");
}
}
}
}
cstMemberInfo.ShortName = m.MemberAbbr;
if (m.PostCode.Length > 6)
{
throw new Exception(m.MemberName + ",会员邮编不能超过6个字符！");
}
cstMemberInfo.PostCode = m.PostCode;
cstMemberInfo.ProvinceID = m.ProvinceID;
if (whenSubmit)
{
if (int.TryParse(m.SuperID, out tempId))
{
if (int.Parse(m.SuperID) <= 0)
{
throw new Exception(m.MemberName + ",请选择上级公司！");
}
}
else
{
throw new Exception(m.MemberName + ",请选择上级公司！");
}
}
cstMemberInfo.SuperId = int.Parse(m.SuperID);
cstMemberInfo.VendorClass = int.Parse(m.MemberType);
cstMembers.Add(cstMemberInfo);
if (whenSubmit)
{
if (m.MemberType == "2" & m.Brand.Length == 0)
{
throw new Exception(m.MemberName + ",至少选择一个主营品牌！");
}
}
string[] brandIds = m.Brand.Split(',');
if (m.Brand.Length > 0)
{
cstMemberBrandsArry.Add(m.Brand);
}
else
{
cstMemberBrandsArry.Add(string.Empty);
}
Entities.ProjectTask_CSTLinkMan linkManInfo = new Entities.ProjectTask_CSTLinkMan();
linkManInfo.CreateTime = DateTime.Now;
if (whenSubmit)
{
bool isOpen = false;
if (int.TryParse(m.MemberID, out tempId))
{
isOpen = BLL.ProjectTask_CSTMember.Instance.IsOpenSuccessMember(tempId);
}
if (!isOpen)
{
if (m.Email.Length == 0)
{
throw new Exception(m.MemberName + ",企业联系人邮件不能为空！");
}
if (m.Mobile.Length == 0)
{
throw new Exception(m.MemberName + ",企业联系人手机不能为空！");
}
if (m.LinkManName.Length == 0)
{
throw new Exception(m.MemberName + ",企业联系人名称不能为空！");
}
}
}
//linkManInfo.Department = m.Department;
linkManInfo.Email = m.Email;
linkManInfo.Mobile = m.Mobile;
linkManInfo.Name = m.LinkManName;
//linkManInfo.Position = m.Position;
linkManInfo.PTID = cust.PTID;
linkManInfo.Status = 0;
linkManInfo.CreateTime = DateTime.Now;
linkManInfo.CreateUserID = BLL.Util.GetLoginUserID();
//throw new Exception("抛出");
cstLinkMans.Add(linkManInfo);
}
}
#endregion
}
private static Entities.ProjectTask_CSTMember LoadSingleProjectTask_CSTMember(DataRow row)
{
Entities.ProjectTask_CSTMember model = new Entities.ProjectTask_CSTMember();
if (row["ID"] != DBNull.Value)
{
model.ID = Convert.ToInt32(row["ID"].ToString());
}
if (row["PTID"] != DBNull.Value)
{
model.PTID = row["PTID"].ToString();
}
if (row["OriginalCSTRecID"] != DBNull.Value)
{
model.OriginalCSTRecID = row["OriginalCSTRecID"].ToString();
}
if (row["VendorCode"] != DBNull.Value)
{
model.VendorCode = row["VendorCode"].ToString();
}
if (row["FullName"] != DBNull.Value)
{
model.FullName = row["FullName"].ToString();
}
if (row["ShortName"] != DBNull.Value)
{
model.ShortName = row["ShortName"].ToString();
}
if (row["VendorClass"] != DBNull.Value)
{
model.VendorClass = int.Parse(row["VendorClass"].ToString());
}
if (row["SuperId"] != DBNull.Value)
{
model.SuperId = int.Parse(row["SuperId"].ToString());
}
if (row["ProvinceID"] != DBNull.Value)
{
model.ProvinceID = row["ProvinceID"].ToString();
}
if (row["CityID"] != DBNull.Value)
{
model.CityID = row["CityID"].ToString();
}
if (row["CountyID"] != DBNull.Value)
{
model.CountyID = row["CountyID"].ToString();
}
if (row["Address"] != DBNull.Value)
{
model.Address = row["Address"].ToString();
}
if (row["PostCode"] != DBNull.Value)
{
model.PostCode = row["PostCode"].ToString();
}
if (row["TrafficInfo"] != DBNull.Value)
{
model.TrafficInfo = row["TrafficInfo"].ToString();
}
if (row["CreateTime"] != DBNull.Value)
{
model.CreateTime = Convert.ToDateTime(row["CreateTime"].ToString());
}
if (row["CreateUserID"] != DBNull.Value)
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
if (row["Status"] != DBNull.Value)
{
model.Status = Convert.ToInt32(row["Status"].ToString());
}
//if (row["SyncStatus"] != DBNull.Value)
//{
// model.SyncStatus = Convert.ToInt32(row["SyncStatus"].ToString());
//}
return(model);
}
