/// <summary>
/// Получить список составов за указаный период согласно правила копирования
/// </summary>
/// <param name="start"></param>
/// <param name="stop"></param>
/// <returns></returns>
public IQueryable <NumVagStpr1InStDoc> GetNumVagStpr1InStDocIsRules(DateTime start, DateTime stop)
{
List <OracleRules> list = orc.GetRulesCopyToOracleRulesOfKis(typeOracleRules.Input);
string wh = null;
return(vc.GetSTPR1InStDocOfAmkr(wh.ConvertWhere(list, "a.k_stan", "st_in_st ", "OR")).Where(v => v.DATE_IN_ST >= start & v.DATE_IN_ST <= stop));
}
public void Test_KIS_RulesCopy_GetRulesCopyToOracleRules()
{
List <OracleRules> list = rc.GetRulesCopyToOracleRules(typeOracleRules.Input);
List <OracleRules> list1 = rc.GetRulesCopyToOracleRulesOfKis(typeOracleRules.Input);
string wh1 = "";
wh1 = wh1.ConvertWhere(list, "k_stan", "st_in_st ", "OR");
string wh2 = "";
wh2 = wh2.ConvertWhere(list1, "a.k_stan", "st_in_st ", "OR");
}
public void Test_VagonsContent_GetSTPR1InStDocOfAmkrWhere()
{
RulesCopy rc = new RulesCopy();
List <OracleRules> list = rc.GetRulesCopyToOracleRulesOfKis(typeOracleRules.Input);
string wh = "";
DateTime dt = DateTime.Now.AddDays(-2);
foreach (NumVagStpr1InStDoc t in vc.GetSTPR1InStDocOfAmkr(wh.ConvertWhere(list, "a.k_stan", "st_in_st ", "OR")).Where(v => v.DATE_IN_ST > dt))
{
WL(t);
}
}