private void BindData() { //查询第一个经销商 List <BitAuto.YanFa.Crm2009.Entities.DMSMember> list = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMember(CustID); if (list != null && list.Count > 0) { FirstMemberCode = list[0].MemberCode; FirstMemberName = list[0].Name; } //查询 int totalCount = 0; BitAuto.YanFa.Crm2009.Entities.QueryContactInfo qci = new BitAuto.YanFa.Crm2009.Entities.QueryContactInfo(); qci.CustID = CustID; DataTable table = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfo(qci, "ModifyTime desc", ch.CurrentPage, ch.PageSize, out totalCount); //设置数据源 if (table != null && table.Rows.Count > 0) { repeater_Contact.DataSource = table; } //绑定列表数据 repeater_Contact.DataBind(); //分页控件 this.AjaxPager_Contact.InitPager(totalCount, "ContactInfoContent", ch.PageSize, ch.CurrentPage); }
private void BindData() { //查询 int totalCount = 0; BitAuto.YanFa.Crm2009.Entities.QueryContactInfo qci = new BitAuto.YanFa.Crm2009.Entities.QueryContactInfo(); qci.CustID = ch.CustID; DataTable table = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfo(qci, "ModifyTime DESC", ch.CurrentPage, PageSize, out totalCount); //设置数据源 if (table != null && table.Rows.Count > 0) { repeater_Contact.DataSource = table; } //绑定列表数据 repeater_Contact.DataBind(); //分页控件 AjaxPager_Contact.PageSize = 5; AjaxPager_Contact.InitPager(totalCount); }
/// <summary> /// 合同和它的金额(数组:0-总金额 1-现有金额) /// </summary> //private Dictionary<string, decimal[]> contractMoney = new Dictionary<string, decimal[]>(); /// <summary> /// 校验 /// </summary> private bool Valid(int rowNum, IDataReader reader, List <MagezineInfoImportExceptionInfo> exceptionInfoList, Dictionary <Entities.CC_MagazineReturn, string> magezineInfoList) { bool currentSuccess = true; MagezineInfoImportExceptionInfo ex = new MagezineInfoImportExceptionInfo(); #region validate string custId = reader[0].ToString().Trim(); string memberCode = reader[2].ToString().Trim(); string contacter = reader[4].ToString().Trim();; int contractId = -1; string dmsMemberID = string.Empty; if (string.IsNullOrEmpty(custId) && string.IsNullOrEmpty(memberCode) && string.IsNullOrEmpty(contacter)) { return(currentSuccess);//此行为空行 } //判断UserID参数 int intval = 0; if (!int.TryParse(UserID, out intval)) { ex.Info.Append("用户ID参数不正确"); currentSuccess = false; } //客户信息验证 if (string.IsNullOrEmpty(custId)) { ex.Info.Append("第" + rowNum + "行此[客户ID]不可为空。"); currentSuccess = false; } else { BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(custId); if (custInfo == null) { ex.Info.Append("第" + rowNum + "行此[客户ID]不存在。"); currentSuccess = false; } } //会员信息验证 if (string.IsNullOrEmpty(memberCode)) { ex.Info.Append("第" + rowNum + "行此[会员ID]不可为空。"); currentSuccess = false; } else { List <BitAuto.YanFa.Crm2009.Entities.DMSMember> dmsMembers = BitAuto.YanFa.Crm2009.BLL.DMSMember.Instance.GetDMSMemberByCustID(custId); if (dmsMembers == null) { ex.Info.Append("第" + rowNum + "行此[会员ID]不存在。"); currentSuccess = false; } else { bool isExist = false; foreach (BitAuto.YanFa.Crm2009.Entities.DMSMember dmsMember in dmsMembers) { if (dmsMember.MemberCode == memberCode.Trim()) { isExist = true; dmsMemberID = dmsMember.ID.ToString(); } } if (!isExist) { ex.Info.Append("第" + rowNum + "行此客户下不存在此[会员ID]。"); currentSuccess = false; } } } if (string.IsNullOrEmpty(contacter)) { ex.Info.Append("第" + rowNum + "行此[联系人]不可为空。"); currentSuccess = false; } else { contacter = contacter.Replace(',', ','); string[] contacterArry = contacter.Split(','); foreach (string cter in contacterArry) { BitAuto.YanFa.Crm2009.Entities.QueryContactInfo query = new BitAuto.YanFa.Crm2009.Entities.QueryContactInfo(); query.CustID = custId; query.CName = cter.Trim(); int totalCount = 0; DataTable dt = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfo(query, "", 1, 1, out totalCount); if (dt.Rows.Count <= 0) { ex.Info.Append("第" + rowNum + "行联系人<" + cter + ">不存在。"); currentSuccess = false; } else { contractId = int.Parse(dt.Rows[0]["ID"].ToString()); } } } if (string.IsNullOrEmpty(CooperationName)) { ex.Info.Append("合作名称不能为空"); currentSuccess = false; } else { Entities.QueryCC_MagazineReturn query = new Entities.QueryCC_MagazineReturn(); query.Title = "第" + cooperationName + "期"; query.Status = 0; query.DMSMemberID = dmsMemberID; int totalCount = 0; DataTable dt = BLL.CC_MagazineReturn.Instance.GetCC_MagazineReturn(query, "", 1, 1, out totalCount); if (dt.Rows.Count > 0) { ex.Info.Append("第" + rowNum + "行已经存在此期的会员"); currentSuccess = false; } } #endregion //如通过则插入数据 if (currentSuccess) { Entities.CC_MagazineReturn info = new Entities.CC_MagazineReturn(); info.ContactID = contractId; info.CreateTime = DateTime.Now; info.CreateUserID = int.Parse(UserID); info.CustID = custId; info.DMSMemberID = dmsMemberID; info.Title = "第" + cooperationName + "期"; info.Status = 0; magezineInfoList.Add(info, contacter); } else { exceptionInfoList.Add(ex); } return(currentSuccess); }