/*
* public CrmRuleValue FindRuleValue(DateTime saleTime, CrmArticle article)
* {
* if ((saleTime.CompareTo(BeginTime) > 0) && (saleTime.CompareTo(EndTime) < 0) && (SubBillList != null))
* {
* foreach (CrmRuleSubBill subBill in SubBillList)
* {
* CrmRuleValue ruleValue = subBill.FindRuleValue(saleTime,article);
* if (ruleValue != null)
* {
* ruleValue.RuleBill = this;
* return ruleValue;
* }
* }
* }
* return null;
* }
*/
public CrmRuleValue FindRuleValue(DateTime saleTime, CrmVipCard vipCard, CrmArticle article)
{
if ((saleTime.CompareTo(BeginTime) > 0) && (saleTime.CompareTo(EndTime) < 0) && (SubBillList != null))
{
foreach (CrmRuleSubBill subBill in SubBillList)
{
CrmRuleValue ruleValue = subBill.FindRuleValue(saleTime, vipCard, article);
if (ruleValue != null)
{
//ruleValue.RuleBill = this;
return(ruleValue);
}
}
}
return(null);
}
public CrmRuleValue FindRuleValue(DateTime saleTime, CrmVipCard vipCard, CrmArticle article, int payType, CrmBankCardPayment bankCard, out CrmBankCardCodeScope bankCardCodeScope)
{
bankCardCodeScope = null;
if ((saleTime.CompareTo(BeginTime) > 0) && (saleTime.CompareTo(EndTime) < 0) && (SubBillList != null))
{
foreach (CrmRuleSubBill subBill in SubBillList)
{
CrmRuleValue ruleValue = subBill.FindRuleValue(saleTime, vipCard, article, payType, bankCard, out bankCardCodeScope);
if (ruleValue != null)
{
//ruleValue.RuleBill = this;
return(ruleValue);
}
}
}
return(null);
}
protected override void GetRuleBillDetail(ChangYi.Crm.Rule.CrmRuleBill bill)
{
DbConnection conn = DbConnManager.GetDbConnection("CRMDB");
DbCommand cmd = conn.CreateCommand();
DbDataReader reader = null;
StringBuilder sql = new StringBuilder();
try
{
try
{
conn.Open();
}
catch (Exception e)
{
throw new MyDbException(e.Message, true);
}
try
{
sql.Length = 0;
sql.Append("select INX,KSRQ,JSRQ,SD from HYKZKDYD_FD where JLBH = ").Append(bill.BillId);
sql.Append(" order by INX");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (bill.SubBillList == null)
{
bill.SubBillList = new List <CrmRuleSubBill>();
}
CrmRuleSubBill subBill = new CrmRuleSubBill();
bill.SubBillList.Add(subBill);
subBill.Inx = DbUtils.GetInt(reader, 0);
if (!reader.IsDBNull(1))
{
subBill.BeginTime = DbUtils.GetDateTime(reader, 1);
}
else
{
subBill.BeginTime = bill.BeginTime;
}
if (!reader.IsDBNull(2))
{
subBill.EndTime = DbUtils.GetDateTime(reader, 2);
}
else
{
subBill.EndTime = bill.EndTime;
}
if (reader.IsDBNull(3))
{
for (int i = 0; i < 48; i++)
{
subBill.Period[i] = 0xFF;
}
}
else
{
reader.GetBytes(3, 0, subBill.Period, 0, 48);
}
}
reader.Close();
if ((bill.SubBillList != null) && (bill.SubBillList.Count() > 0))
{
List <int> listInt = new List <int>();
List <CrmRuleValue> listRuleValue = new List <CrmRuleValue>();
DbParameter param = null;
sql.Length = 0;
sql.Append("select SHSPID,BJ_CJ,ZKL,ZSZKL,CLFS_JD from HYKZKDYD_SP where JLBH = ").Append(bill.BillId);
DbUtils.SpellSqlParameter(conn, sql, " and ", "INX", "=");
sql.Append(" order by SHSPID");
cmd.CommandText = sql.ToString();
cmd.Parameters.Clear();
param = DbUtils.AddIntInputParameter(cmd, "INX");
foreach (CrmRuleSubBill subBill in bill.SubBillList)
{
listInt.Clear();
listRuleValue.Clear();
param.Value = subBill.Inx;
reader = cmd.ExecuteReader();
while (reader.Read())
{
listInt.Add(DbUtils.GetInt(reader, 0));
CrmRuleValue ruleValue = new CrmRuleValue();
listRuleValue.Add(ruleValue);
ruleValue.IsJoined = DbUtils.GetBool(reader, 1);
ruleValue.DoubleValue = DbUtils.GetDouble(reader, 2);
ruleValue.DoubleValue2 = DbUtils.GetDouble(reader, 3);
ruleValue.DoubleDigits = DbUtils.GetInt(reader, 4);
ruleValue.Bill = bill;
ruleValue.SubBill = subBill;
}
reader.Close();
if (listInt.Count() > 0)
{
subBill.ArticleIds = listInt.ToArray <int>();
subBill.ArticleRuleValues = listRuleValue.ToArray <CrmRuleValue>();
}
}
sql.Length = 0;
sql.Append("select GZBH,ZKL,ZSZKL,CLFS_JD,BJ_CJ,CLFS_BM,CLFS_SPFL,CLFS_SPSB,CLFS_HT,CLFS_HYZ,CLFS_SP from HYKZKDYD_GZSD where JLBH = ").Append(bill.BillId);
DbUtils.SpellSqlParameter(conn, sql, " and ", "INX", "=");
sql.Append(" order by GZBH");
cmd.CommandText = sql.ToString();
cmd.Parameters.Clear();
param = DbUtils.AddIntInputParameter(cmd, "INX");
foreach (CrmRuleSubBill subBill in bill.SubBillList)
{
param.Value = subBill.Inx;
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (subBill.Items == null)
{
subBill.Items = new List <CrmRuleBillItem>();
}
CrmRuleBillItem ruleItem = new CrmRuleBillItem();
subBill.Items.Add(ruleItem);
ruleItem.Inx = DbUtils.GetInt(reader, 0);
ruleItem.RuleValue.DoubleValue = DbUtils.GetDouble(reader, 1);
ruleItem.RuleValue.DoubleValue2 = DbUtils.GetDouble(reader, 2);
ruleItem.RuleValue.DoubleDigits = DbUtils.GetInt(reader, 3);
ruleItem.RuleValue.IsJoined = DbUtils.GetBool(reader, 4);
ruleItem.ExistDept = (DbUtils.GetInt(reader, 5) > 0);
ruleItem.ExistCategory = (DbUtils.GetInt(reader, 6) > 0);
ruleItem.ExistBrand = (DbUtils.GetInt(reader, 7) > 0);
ruleItem.ExistContract = (DbUtils.GetInt(reader, 8) > 0);
ruleItem.ExistVipGroup = (DbUtils.GetInt(reader, 9) > 0);
ruleItem.ExistArticle = (DbUtils.GetInt(reader, 10) > 0);
ruleItem.RuleValue.Bill = bill;
ruleItem.RuleValue.SubBill = subBill;
ruleItem.RuleValue.BillItem = ruleItem;
}
reader.Close();
}
cmd.Parameters.Clear();
List <string> listStr = new List <string>();
foreach (CrmRuleSubBill subBill in bill.SubBillList)
{
if (subBill.Items != null)
{
foreach (CrmRuleBillItem ruleItem in subBill.Items)
{
if (ruleItem.ExistDept)
{
listStr.Clear();
sql.Length = 0;
sql.Append("select b.BMDM from HYKZKDYD_GZITEM a, SHBM b where a.SJLX = 1 and a.SJNR = b.SHBMID and a.SJNR > 0 and a.JLBH = ").Append(bill.BillId);
sql.Append(" and a.INX = ").Append(subBill.Inx);
sql.Append(" and a.GZBH = ").Append(ruleItem.Inx);
sql.Append(" order by b.BMDM");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
listStr.Add(DbUtils.GetString(reader, 0).Trim());
}
reader.Close();
if (listStr.Count == 0)
{
ruleItem.ExistDept = false;
}
else
{
ruleItem.DeptCodes = listStr.ToArray <string>();
}
}
if (ruleItem.ExistContract)
{
listInt.Clear();
sql.Length = 0;
sql.Append("select a.SJNR from HYKZKDYD_GZITEM a where a.SJLX = 2 and a.SJNR > 0 and a.JLBH = ").Append(bill.BillId);
sql.Append(" and a.INX = ").Append(subBill.Inx);
sql.Append(" and a.GZBH = ").Append(ruleItem.Inx);
sql.Append(" order by a.SJNR");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
listInt.Add(DbUtils.GetInt(reader, 0));
}
reader.Close();
if (listInt.Count == 0)
{
ruleItem.ExistContract = false;
}
else
{
ruleItem.ContractIds = listInt.ToArray <int>();
}
}
if (ruleItem.ExistCategory)
{
listStr.Clear();
sql.Length = 0;
sql.Append("select b.SPFLDM from HYKZKDYD_GZITEM a,SHSPFL b where a.SJLX = 3 and a.SJNR = b.SHSPFLID and a.SJNR > 0 and a.JLBH = ").Append(bill.BillId);
sql.Append(" and a.INX = ").Append(subBill.Inx);
sql.Append(" and a.GZBH = ").Append(ruleItem.Inx);
sql.Append(" order by b.SPFLDM");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
listStr.Add(DbUtils.GetString(reader, 0).Trim());
}
reader.Close();
if (listStr.Count == 0)
{
ruleItem.ExistCategory = false;
}
else
{
ruleItem.CategoryCodes = listStr.ToArray <string>();
}
}
if (ruleItem.ExistBrand)
{
listInt.Clear();
sql.Length = 0;
sql.Append("select a.SJNR from HYKZKDYD_GZITEM a where a.SJLX = 4 and a.SJNR > 0 and a.JLBH = ").Append(bill.BillId);
sql.Append(" and a.INX = ").Append(subBill.Inx);
sql.Append(" and a.GZBH = ").Append(ruleItem.Inx);
sql.Append(" order by a.SJNR");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
listInt.Add(DbUtils.GetInt(reader, 0));
}
reader.Close();
if (listInt.Count == 0)
{
ruleItem.ExistBrand = false;
}
else
{
ruleItem.BrandIds = listInt.ToArray <int>();
}
}
if (ruleItem.ExistVipGroup)
{
listInt.Clear();
sql.Length = 0;
sql.Append("select a.SJNR from HYKZKDYD_GZITEM a where a.SJLX = 5 and a.SJNR > 0 and a.JLBH = ").Append(bill.BillId);
sql.Append(" and a.INX = ").Append(subBill.Inx);
sql.Append(" and a.GZBH = ").Append(ruleItem.Inx);
sql.Append(" order by a.SJNR");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
listInt.Add(DbUtils.GetInt(reader, 0));
}
reader.Close();
if (listInt.Count == 0)
{
ruleItem.ExistVipGroup = false;
}
else
{
ruleItem.VipGroups = new List <CrmVipGroup>();
ChangYi.Crm.Server.CrmPubUtils.GetVipGroups(cmd, sql, listInt, ruleItem.VipGroups);
}
}
if (ruleItem.ExistArticle)
{
listInt.Clear();
sql.Length = 0;
sql.Append("select a.SJNR from HYKZKDYD_GZITEM a where a.SJLX = 6 and a.SJNR > 0 and a.JLBH = ").Append(bill.BillId);
sql.Append(" and a.INX = ").Append(subBill.Inx);
sql.Append(" and a.GZBH = ").Append(ruleItem.Inx);
sql.Append(" order by a.SJNR");
cmd.CommandText = sql.ToString();
reader = cmd.ExecuteReader();
while (reader.Read())
{
listInt.Add(DbUtils.GetInt(reader, 0));
}
reader.Close();
if (listInt.Count == 0)
{
ruleItem.ExistArticle = false;
}
else
{
ruleItem.ArticleIds = listInt.ToArray <int>();
}
}
}
}
}
}
}
catch (Exception e)
{
if (e is MyDbException)
{
throw e;
}
else
{
throw new MyDbException(e.Message, cmd.CommandText);
}
}
}
finally
{
conn.Close();
}
}