public static void GetVipCard(DbCommand cmd, StringBuilder sql, CrmVipGroup vipGroup)
{
}
public static void GetVipGroup(DbCommand cmd, StringBuilder sql, CrmVipGroup vipGroup)
{
if (vipGroup.GroupId == 0)
{
return;
}
sql.Length = 0;
sql.Append("select GRPID,SRFS,GZFS from HYK_HYGRP where GRPID = ").Append(vipGroup.GroupId);
cmd.CommandText = sql.ToString();
DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
vipGroup.BirthdayMode = DbUtils.GetInt(reader, 1);
vipGroup.OnlyExistVipId = (DbUtils.GetInt(reader, 2) == 0);
}
reader.Close();
sql.Length = 0;
sql.Append("select SJLX,SJNR from HYK_HYGRP_GZMX where GRPID = ").Append(vipGroup.GroupId);
sql.Append(" order by SJLX,SJNR");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
int dataType = DbUtils.GetInt(reader, 0);
string dataValue = DbUtils.GetString(reader, 1);
if (dataValue.Length > 0)
{
switch (dataType)
{
case 1:
if (vipGroup.VipIds == null)
{
vipGroup.VipIds = new HashSet <int>();
}
vipGroup.VipIds.Add(Convert.ToInt32(dataValue));
break;
case 2:
if (vipGroup.IdCardTypes == null)
{
vipGroup.IdCardTypes = new List <int>();
}
vipGroup.IdCardTypes.Add(Convert.ToInt32(dataValue));
break;
case 3:
if (vipGroup.VipTypes == null)
{
vipGroup.VipTypes = new List <int>();
}
vipGroup.VipTypes.Add(Convert.ToInt32(dataValue));
break;
case 4:
if (vipGroup.SexTypes == null)
{
vipGroup.SexTypes = new List <int>();
}
vipGroup.SexTypes.Add(Convert.ToInt32(dataValue));
break;
case 5:
if (vipGroup.JobTypes == null)
{
vipGroup.JobTypes = new List <int>();
}
vipGroup.JobTypes.Add(Convert.ToInt32(dataValue));
break;
case 6:
if (vipGroup.IssueCardCompanyIds == null)
{
vipGroup.IssueCardCompanyIds = new List <int>();
}
vipGroup.IssueCardCompanyIds.Add(Convert.ToInt32(dataValue));
break;
}
}
}
reader.Close();
}
public static void GetVipGroups(DbCommand cmd, StringBuilder sql, List <int> groupIds, List <CrmVipGroup> vipGroups)
{
if (groupIds.Count == 0)
{
return;
}
sql.Length = 0;
sql.Append("select GRPID,SRFS,GZFS from HYK_HYGRP ");
if (groupIds.Count == 1)
{
sql.Append(" where GRPID = ").Append(groupIds[0]);
}
else
{
sql.Append(" where GRPID in (").Append(groupIds[0]);
for (int i = 1; i < groupIds.Count; i++)
{
sql.Append(",").Append(groupIds[i]);
}
sql.Append(")");
}
cmd.CommandText = sql.ToString();
DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CrmVipGroup vipGroup = new CrmVipGroup();
vipGroups.Add(vipGroup);
vipGroup.GroupId = DbUtils.GetInt(reader, 0);
vipGroup.BirthdayMode = DbUtils.GetInt(reader, 1);
vipGroup.OnlyExistVipId = (DbUtils.GetInt(reader, 2) == 0);
}
reader.Close();
CrmVipGroup vipGroup2 = null;
sql.Length = 0;
sql.Append("select GRPID,SJLX,SJNR from HYK_HYGRP_GZMX ");
if (groupIds.Count == 1)
{
sql.Append(" where GRPID = ").Append(groupIds[0]);
}
else
{
sql.Append(" where GRPID in (").Append(groupIds[0]);
for (int i = 1; i < groupIds.Count; i++)
{
sql.Append(",").Append(groupIds[i]);
}
sql.Append(")");
}
sql.Append(" order by GRPID,SJLX,SJNR");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
int groupId = DbUtils.GetInt(reader, 0);
int dataType = DbUtils.GetInt(reader, 1);
string dataValue = DbUtils.GetString(reader, 2);
if (dataValue.Length > 0)
{
if ((vipGroup2 == null) || (vipGroup2.GroupId != groupId))
{
foreach (CrmVipGroup vipGroup in vipGroups)
{
if (vipGroup.GroupId == groupId)
{
vipGroup2 = vipGroup;
break;
}
}
}
if (vipGroup2 == null)
{
vipGroup2 = new CrmVipGroup();
vipGroup2.GroupId = groupId;
}
}
switch (dataType)
{
case 1:
if (vipGroup2.VipIds == null)
{
vipGroup2.VipIds = new HashSet <int>();
}
vipGroup2.VipIds.Add(Convert.ToInt32(dataValue));
break;
case 2:
if (vipGroup2.IdCardTypes == null)
{
vipGroup2.IdCardTypes = new List <int>();
}
vipGroup2.IdCardTypes.Add(Convert.ToInt32(dataValue));
break;
case 3:
if (vipGroup2.VipTypes == null)
{
vipGroup2.VipTypes = new List <int>();
}
vipGroup2.VipTypes.Add(Convert.ToInt32(dataValue));
break;
case 4:
if (vipGroup2.SexTypes == null)
{
vipGroup2.SexTypes = new List <int>();
}
vipGroup2.SexTypes.Add(Convert.ToInt32(dataValue));
break;
case 5:
if (vipGroup2.JobTypes == null)
{
vipGroup2.JobTypes = new List <int>();
}
vipGroup2.JobTypes.Add(Convert.ToInt32(dataValue));
break;
case 6:
if (vipGroup2.IssueCardCompanyIds == null)
{
vipGroup2.IssueCardCompanyIds = new List <int>();
}
vipGroup2.IssueCardCompanyIds.Add(Convert.ToInt32(dataValue));
break;
}
}
reader.Close();
}
