/// <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); } } } }