/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_CSTLinkMan model)
{
SqlParameter[] parameters =
{
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@CSTMemberID", SqlDbType.Int, 4),
new SqlParameter("@OriginalCSTLinkManID", SqlDbType.Int, 4),
new SqlParameter("@CSTRecID", SqlDbType.VarChar, 10),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Department", SqlDbType.NVarChar, 100),
new SqlParameter("@Position", SqlDbType.NVarChar, 100),
new SqlParameter("@Mobile", SqlDbType.NVarChar, 100),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.PTID;
parameters[1].Value = model.CSTMemberID;
parameters[2].Value = model.OriginalCSTLinkManID;
parameters[3].Value = model.CSTRecID;
parameters[4].Value = model.Name;
parameters[5].Value = model.Department;
parameters[6].Value = model.Position;
parameters[7].Value = model.Mobile;
parameters[8].Value = model.Email;
parameters[9].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTLINKMAN_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.ProjectTask_CSTLinkMan model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@CSTMemberID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Department", SqlDbType.NVarChar, 100),
new SqlParameter("@Position", SqlDbType.NVarChar, 100),
new SqlParameter("@Mobile", SqlDbType.NVarChar, 100),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.PTID;
parameters[2].Value = model.CSTMemberID;
parameters[3].Value = model.Name;
parameters[4].Value = model.Department;
parameters[5].Value = model.Position;
parameters[6].Value = model.Mobile;
parameters[7].Value = model.Email;
parameters[8].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CSTLINKMAN_INSERT, parameters);
return((int)parameters[0].Value);
}
private Entities.ProjectTask_CSTLinkMan LoadSingleProjectTask_CSTLinkMan(DataRow row)
{
Entities.ProjectTask_CSTLinkMan model = new Entities.ProjectTask_CSTLinkMan();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
if (row["PTID"].ToString() != "")
{
model.PTID = row["PTID"].ToString();
}
if (row["CSTMemberID"].ToString() != "")
{
model.CSTMemberID = int.Parse(row["CSTMemberID"].ToString());
}
if (row["OriginalCSTLinkManID"].ToString() != "")
{
model.OriginalCSTLinkManID = int.Parse(row["OriginalCSTLinkManID"].ToString());
}
model.CSTRecID = row["CSTRecID"].ToString();
model.Name = row["Name"].ToString();
model.Department = row["Department"].ToString();
model.Position = row["Position"].ToString();
model.Mobile = row["Mobile"].ToString();
model.Email = row["Email"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
return(model);
}
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
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_CSTLinkMan model)
{
return(Dal.ProjectTask_CSTLinkMan.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.ProjectTask_CSTLinkMan model)
{
return(Dal.ProjectTask_CSTLinkMan.Instance.Insert(model));
}
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();
}
}
}
}
}
/// <summary>
/// 提交核实的信息(客户与会员)
/// </summary>
public void SubmitCheckedInfo(Entities.ProjectTask_Cust cust, List <Entities.ProjectTask_DMSMember> members, List <Entities.ProjectTask_CSTMember> cstMembers, List <Entities.ProjectTask_CSTLinkMan> linkMans, List <string> cstMemberBrands, DateTime dtime)
{
Entities.ProjectTask_Cust oldCustInfo = BLL.ProjectTask_Cust.Instance.GetProjectTask_Cust(cust.PTID);
//如果更改经营范围
if (oldCustInfo.CarType != 1 && cust.CarType == 1)
{
//删除客户二手车相关信息
cust.CstMemberID = string.Empty;
cust.TradeMarketID = string.Empty;
cust.UsedCarBusinessType = string.Empty;
//删除二手车相关
IList <Entities.ProjectTask_BusinessScale> businessScaleList = BLL.ProjectTask_BusinessScale.Instance.GetAllProjectTask_BusinessScaleByTID(cust.PTID);
foreach (Entities.ProjectTask_BusinessScale busInfo in businessScaleList)
{
BLL.ProjectTask_BusinessScale.Instance.Delete(busInfo.RecID);
}
//删除车商通会员
IList <Entities.ProjectTask_CSTMember> memberList = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(cust.PTID.ToString());
foreach (Entities.ProjectTask_CSTMember cstMemberInfo in memberList)
{
BLL.ProjectTask_CSTMember.Instance.Delete(cstMemberInfo.ID);
}
}
this.Update(cust);
int i = 0;
foreach (Entities.ProjectTask_DMSMember member in members)
{
member.PTID = cust.PTID;
BLL.ProjectTask_DMSMember.Instance.InsertOrUpdate(member);
//删除会员保存数据
i++;
}
#region 车商通信息插入
if (cust.TypeID != "1")
{
if (cstMembers != null)
{
int count = 0;
foreach (Entities.ProjectTask_CSTMember cstMemberInfo in cstMembers)
{
int recId = -1;
if (cstMemberInfo.ID > 0)
{
recId = cstMemberInfo.ID;
linkMans[count].CSTMemberID = recId;
linkMans[count].PTID = cust.PTID;
cstMemberInfo.PTID = cust.PTID;
BLL.ProjectTask_CSTMember.Instance.Update(cstMemberInfo);
//插入车商通会员品牌
InsertCstMemberBrand(cstMemberBrands, count, cstMemberInfo.ID);
}
else
{
cstMemberInfo.PTID = cust.PTID;
recId = BLL.ProjectTask_CSTMember.Instance.Insert(cstMemberInfo);
//插入车商通会员品牌
InsertCstMemberBrand(cstMemberBrands, count, recId);
linkMans[count].CSTMemberID = recId;
linkMans[count].PTID = cust.PTID;
}
count++;
}
foreach (Entities.ProjectTask_CSTLinkMan linkMan in linkMans)
{
//如果是开通的会员，不进行任何修改
if (!BLL.ProjectTask_CSTMember.Instance.IsOpenSuccessMember((int)linkMan.CSTMemberID))
{
Entities.QueryProjectTask_CSTLinkMan linkManQuery = new QueryProjectTask_CSTLinkMan();
linkManQuery.CSTMemberID = linkMan.CSTMemberID;
int total = 0;
DataTable dt = BLL.ProjectTask_CSTLinkMan.Instance.GetProjectTask_CSTLinkMan(linkManQuery, "", 1, 1, out total);
if (total > 0)
{
Entities.ProjectTask_CSTLinkMan linkManInfo = BLL.ProjectTask_CSTLinkMan.Instance.GetProjectTask_CSTLinkMan(int.Parse(dt.Rows[0]["RecID"].ToString()));
linkManInfo.Department = linkMan.Department;
linkManInfo.Email = linkMan.Email;
linkManInfo.Mobile = linkMan.Mobile;
linkManInfo.Name = linkMan.Name;
linkManInfo.Position = linkMan.Position;
BLL.ProjectTask_CSTLinkMan.Instance.Update(linkManInfo);
}
else
{
BLL.ProjectTask_CSTLinkMan.Instance.Insert(linkMan);
}
}
}
}
}
#endregion
//任务状态,处理完成后改为待审核
BLL.ProjectTaskInfo.Instance.UpdateTaskStatus(cust.PTID, Entities.EnumProjectTaskStatus.SubmitFinsih, EnumProjectTaskOperationStatus.TaskSubmit, "", dtime);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//this.tfCstMemberShortName.Attributes.Add("onblur", "javascript:uCEditCstMemberHelper_" + ID + ".createMemberCode();");
this.sltCstLinkMan.Attributes.Add("onchange", "uCEditCstMemberHelper_" + ID + ".getContactInfo()");
BindSuperCompany();
BindContrats();
string memberId = string.Empty;
string originalDMSMemberID = string.Empty;
if (this.Member != null)
{
if (!string.IsNullOrEmpty(this.Member.OriginalCSTRecID))
{
CrmMember = "Crm";
this.tfCstMemberAddress.Attributes.Add("disabled", "disabled");
this.tfCstMemberFullName.Attributes.Add("disabled", "disabled");
this.tfCstMemberPostCode.Attributes.Add("disabled", "disabled");
this.tfCstMemberShortName.Attributes.Add("disabled", "disabled");
this.tfLinkManEmail.Attributes.Add("disabled", "disabled");
this.tfLinkManMobile.Attributes.Add("disabled", "disabled");
//this.tfVendorCode.Attributes.Add("disabled", "disabled");
this.selCstMemberCity.Attributes.Add("disabled", "disabled");
this.selCstMemberCounty.Attributes.Add("disabled", "disabled");
this.selCstMemberProvince.Attributes.Add("disabled", "disabled");
this.sltSuperId.Attributes.Add("disabled", "disabled");
this.tfLinkManName.Attributes.Add("disabled", "disabled");
this.sltCstLinkMan.Attributes.Add("disabled", "disabled");
}
#region 车商通会员基本信息
originalDMSMemberID = MemberID.ToString();
memberId = Member.ID.ToString();
this.tfCstMemberID.Value = Member.ID.ToString();
this.tfCstMemberFullName.Value = Member.FullName;
this.tfCstMemberShortName.Value = Member.ShortName;
this.tfCstMemberPostCode.Value = Member.PostCode;
this.selCstMemberType.Value = Member.VendorClass.ToString();
//this.tfTrafficInfo.Value = Member.TrafficInfo;
//this.tfVendorCode.Value = Member.VendorCode;
this.tfCstMemberAddress.Value = Member.Address;
this.sltSuperId.Value = Member.SuperId.ToString();
this.selCstMemberType.Value = Member.VendorClass.ToString();
this.InitialProvinceID = Member.ProvinceID;
this.InitialCityID = Member.CityID;
this.InitialCountyID = Member.CountyID;
#endregion
string brandIds = BLL.ProjectTask_CSTMember_Brand.Instance.GetProjectTask_CSTMember_BrandIDs(Member.ID);
this.tfCstMemberBrandName.Value = BitAuto.YanFa.Crm2009.BLL.CarBrand.Instance.GetBrandNames(brandIds);
this.tfCstMemberBrand.Value = brandIds;
#region 车商通会员联系人信息
Entities.ProjectTask_CSTLinkMan linkManInfo = BLL.ProjectTask_CSTLinkMan.Instance.GetProjectTask_CSTLinkManModel(Member.ID);
if (linkManInfo != null)
{
//this.tfLinkManDepartment.Value = linkManInfo.Department;
this.tfLinkManEmail.Value = linkManInfo.Email;
this.tfLinkManMobile.Value = linkManInfo.Mobile;
//this.tfLinkManPosition.Value = linkManInfo.Position;
this.tfLinkManName.Value = linkManInfo.Name;
}
//如果是开通的会员，则不可编辑
bool isopen = false;
if (BLL.ProjectTask_CSTMember.Instance.IsOpenSuccessMember(Member.ID))
{
//是否有名称变更
if (!string.IsNullOrEmpty(Member.OriginalCSTRecID))
{
DataTable dtFullName = BLL.ProjectTask_AuditContrastInfo.Instance.GetProjectTask_AuditContrastInfo(Member.OriginalCSTRecID, 7, "FullName");
if (dtFullName.Rows.Count > 0)
{
FullNameHavHistory = true;
}
}
this.sltSuperId.Disabled = true;
this.sltCstLinkMan.Disabled = true;
//this.tfLinkManDepartment.Disabled = true;
this.tfLinkManEmail.Disabled = true;
this.tfLinkManMobile.Disabled = true;
//this.tfLinkManPosition.Disabled = true;
this.tfLinkManName.Disabled = true;
//this.tfVendorCode.Disabled = true;
isopen = true;
}
#endregion
if (isopen)
{
Control ctl = this.LoadControl("~/CustInfo/DetailV/UCCstMemberUCount.ascx", Member.ID);
this.PlaceHolderCstMemberUCount.Controls.Add(ctl);
}
}
}
}
