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