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; } } } }