public static void Import11x5()
{
List<NumberType> numberTypes = NumberTypeBiz.Instance.GetAll().Where(x => x.RuleType.Contains("11X5")).ToList();
string[] number1 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012" };
string[] number2 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012", "He", "HeWei", "Ji", "JiWei", "KuaDu", "DaXiaoBi", "ZiHeBi", "DanShuangBi", "Lu012Bi" };
string[] number3 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012", "He", "HeWei", "Ji", "JiWei", "KuaDu", "AC", "DaXiaoBi", "ZiHeBi", "DanShuangBi", "Lu012Bi" };
foreach (var numberType in numberTypes)
{
if (numberType.Code.StartsWith("A")) continue;
Data.Biz.D11X5.DmDPCBiz biz = new Data.Biz.D11X5.DmDPCBiz("jiangx11x5", numberType.Code.GetDmTableSuffix());
List<DimensionNumberType> ntds = new List<DimensionNumberType>();
if (numberType.Length == 1)
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number1, numberType.Code);
else if (numberType.Length == 2)
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number2, numberType.Code);
else
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number3, numberType.Code);
foreach (var ntd in ntds)
{
ntd.NumberType = numberType.Code;
ntd.RuleType = numberType.RuleType;
ntd.Amount = ntd.Nums * numberType.Amount;
ntd.Probability = (ntd.Nums * 1.0) * numberType.Probability;
}
DimensionNumberTypeBiz.Instance.DataAccessor.Insert(ntds, SqlInsertMethod.SqlBulkCopy);
}
}
public static void Import11x5()
{
List <NumberType> numberTypes = NumberTypeBiz.Instance.GetAll().Where(x => x.RuleType.Contains("11X5")).ToList();
string[] number1 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012" };
string[] number2 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012", "He", "HeWei", "Ji", "JiWei", "KuaDu", "DaXiaoBi", "ZiHeBi", "DanShuangBi", "Lu012Bi" };
string[] number3 = new string[] { "DaXiao", "DanShuang", "ZiHe", "Lu012", "He", "HeWei", "Ji", "JiWei", "KuaDu", "AC", "DaXiaoBi", "ZiHeBi", "DanShuangBi", "Lu012Bi" };
foreach (var numberType in numberTypes)
{
if (numberType.Code.StartsWith("A"))
{
continue;
}
Data.Biz.D11X5.DmDPCBiz biz = new Data.Biz.D11X5.DmDPCBiz("jiangx11x5", numberType.Code.GetDmTableSuffix());
List <DimensionNumberType> ntds = new List <DimensionNumberType>();
if (numberType.Length == 1)
{
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number1, numberType.Code);
}
else if (numberType.Length == 2)
{
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number2, numberType.Code);
}
else
{
ntds = biz.DataAccessor.SelectNumberTypeDimGroupBy(number3, numberType.Code);
}
foreach (var ntd in ntds)
{
ntd.NumberType = numberType.Code;
ntd.RuleType = numberType.RuleType;
ntd.Amount = ntd.Nums * numberType.Amount;
ntd.Probability = (ntd.Nums * 1.0) * numberType.Probability;
}
DimensionNumberTypeBiz.Instance.DataAccessor.Insert(ntds, SqlInsertMethod.SqlBulkCopy);
}
}