public static OtdelFormul Formuls()
{
OtdelFormul shemeformulotdel = new OtdelFormul();
shemeformulotdel.ShemeOtdelFormul.Add(new OtdelFormul()
{
Index = 1,
Name = "Отбор ЗГ",
Discription = "Отбор ЗГ поступившие за период или день",
Formula = @"@Select(@Contains(" + LotusItem.DbZgItem.Dept + ";\"{0}\") & ( @Date(" + LotusItem.DbZgItem.DataReg + ")>= @Date({1}) & @Date(" + LotusItem.DbZgItem.DataReg + ") <= @Date({2})))"
});
shemeformulotdel.ShemeOtdelFormul.Add(new OtdelFormul()
{
Index = 2,
Name = "ЗГ со статусом",
Discription = "ЗГ со статусом",
Formula = @"@Select(@Contains(" + LotusItem.DbZgItem.Dept + ";\"{0}\")&( @Date(@Created)>= @Date({1}) & @Date(@Created) <= @Date({2}))&(@Contains(" + LotusItem.DbZgItem.StatusZg + ";\"{3}\")) )"
});
return(shemeformulotdel);
}
public void FormulSwith(ModelZg modelZg, string databasepath, ModelImnsOtdel otdel, CalendarModel calendar, Status status, OtdelFormul formul, Loading Load)
{
SeathZg seathzg = new SeathZg();
if (!formul.IsValidation())
{
}
else
{
switch (formul.SelectfFormul.Index)
{
case 1:
if (!otdel.IsValidation() || !calendar.IsValidation())
{
break;
}
{
seathzg.SeathZgOtdel(databasepath, modelZg, Formula.GenerateFormula(formul.SelectfFormul.Formula, otdel.SelectOtdel.OtdelDepartament,
calendar.Stardatetime, calendar.EndDateTime), Load); break;
}
case 2:
if (!otdel.IsValidation() || !calendar.IsValidation() || !status.IsValidation())
{
break;
}
{
seathzg.SeathZgOtdel(databasepath, modelZg, Formula.GenerateFormula(formul.SelectfFormul.Formula, otdel.SelectOtdel.OtdelDepartament,
calendar.Stardatetime, calendar.EndDateTime, status.Selectstatus.StatusZg), Load); break;
}
}
}
}
