//public void addPLUSummary(int prodid, string prodname, int tsell, int tsumm, int tweight, DateTime cleared) //{ // Scale.addPLUSummary(sql, prodid, prodname, tsell, tsumm, tweight, cleared); //} //public List<ScalePLUSummary> getPluSummarys(DateTime date) //{ // return Scale.getPluSummarys(sql, date); //} //public void deletePLUsummary(int sid, DateTime lastClear) //{ // Scale.DeletePLUsumary(sql, sid, lastClear); //} #endregion butcher public XmlDocument makeReport(myReportType type, Filters f) { if (!this.services.ContainsKey("Reports")) { this.services.Add("Reports", new Reports(sql)); } return((this.services["Reports"] as Reports).makeReport(type, f)); }
public ReportViewForm(myReportType type, XmlDocument[] xml) : this() { this._repType = type; this._repFile = ReportHelper.GetFileName(type); this._repName = ReportHelper.GetRusName(type); this._xclHeaders = ReportHelper.GetHeaders(_repType); build(xml); }
public static string[] GetHeaders(myReportType repType) { switch (repType) { case myReportType.BREEDS: return(new string[] { "№", "Порода", "Производители", "Кандидаты", "Мальчики", "Штатные", "Первокролки", "Невесты", "Девочки", "Безполые", "Всего" }); case myReportType.AGE: return(new string[] { "Возраст", "Количество" }); case myReportType.BY_MONTH: return(new string[] { "Дата", "Всего", "Осталось" }); case myReportType.DEADREASONS: return(new string[] { "Причина", "Количество" }); case myReportType.DEAD: return(new string[] { "Дата", "Имя", "Количество", "Причина", "Заметки" }); case myReportType.FUCKS_BY_DATE: return(new string[] { "Дата", "Самка", "Самец", "Работник" }); default: return(new string[] { }); } }
public PeriodForm(myReportType type) : this() { switch (type) { case myReportType.DEAD: lbReportName.Text = "Списания"; break; case myReportType.DEADREASONS: lbReportName.Text = "Причины списаний"; break; case myReportType.FUCKS_BY_DATE: lbReportName.Text = "Список случек и вязок"; break; } this.ReportType = type; }
private void tsmiFucksByUsers_Click(object sender, EventArgs e) { OkrolUser dlg = new OkrolUser(); if (dlg.ShowDialog() == DialogResult.OK) { Filters f = new Filters(); f["user"] = dlg.getUser().ToString(); f[Filters.DATE_PERIOD] = dlg.PeriodChar; f[Filters.DATE_VALUE] = dlg.DateValue; myReportType type = dlg.PeriodChar == "y" ? myReportType.USER_OKROLS_YEAR : myReportType.USER_OKROLS; (new ReportViewForm(type, new XmlDocument[] { Engine.get().db().makeReport(type, f), dlg.getXml() } )).Show(); } }
public static string GetFileName(myReportType type) { switch (type) { case myReportType.AGE: return("age"); case myReportType.BREEDS: return("breeds"); case myReportType.BUTCHER_PERIOD: return("butcher"); case myReportType.BY_MONTH: return("by_month"); case myReportType.DEAD: return("dead"); case myReportType.DEADREASONS: return("deadreason"); case myReportType.F****R: return("f****r"); case myReportType.FUCKS_BY_DATE: return("fucks_by_date"); case myReportType.PRIDE: return("plem"); case myReportType.RABBIT: return("rabbit"); case myReportType.REALIZE: return("realization"); case myReportType.REPLACE: return("replace_plan"); case myReportType.REVISION: return("empty_rev"); case myReportType.SHED: return("shed"); case myReportType.USER_OKROLS: return("okrol_user"); case myReportType.USER_OKROLS_YEAR: return("okrol_user_year"); default: return("test"); } }
public XmlDocument makeReport(myReportType type, Filters f) { String query = ""; switch (type) { case myReportType.AGE: query = ageQuery(f); break; case myReportType.BY_MONTH: query = rabByMonth(); break; case myReportType.BUTCHER_PERIOD: query = butcherQuery(f); break; case myReportType.BREEDS: query = breedsQuery(f); break; case myReportType.DEAD: query = deadQuery(f); break; case myReportType.DEADREASONS: query = deadReasonsQuery(f); break; case myReportType.FUCKS_BY_DATE: query = fucksByDate(f); break; case myReportType.F****R: query = fuckerQuery(f); break; case myReportType.REALIZE: query = realize(f); break; case myReportType.REVISION: return(revision(f)); case myReportType.SHED: return(shedReport(f)); case myReportType.TEST: query = testQuery(f); break; case myReportType.USER_OKROLS_YEAR: case myReportType.USER_OKROLS: return(userOkrolRpt(qUserOkrols(f))); } #if DEBUG _logger.Debug(query); #endif return(makeStdReportXml(query)); }
public static string GetRusName(myReportType type) { switch (type) { case myReportType.AGE: return("Статистика возрастного поголовья"); case myReportType.BREEDS: return("Отчет по породам"); case myReportType.BUTCHER_PERIOD: return("Стерильный цех"); case myReportType.BY_MONTH: return("Количество по месяцам"); case myReportType.DEAD: return("Списания"); case myReportType.DEADREASONS: return("Причины списаний"); case myReportType.F****R: return("Статистика продуктивности"); case myReportType.FUCKS_BY_DATE: return("Список случек и вязок"); case myReportType.PRIDE: return("Племенной список"); case myReportType.RABBIT: return("Племенное свидетельство"); case myReportType.REALIZE: return("Кандидаты на реализацию"); case myReportType.REPLACE: return("План пересадок"); case myReportType.REVISION: return("Ревизия свободных клеток"); case myReportType.SHED: return("Шедовый отчет"); case myReportType.USER_OKROLS_YEAR: case myReportType.USER_OKROLS: return("Окролы по пользователям"); default: return("test"); } }
public ReportViewForm(myReportType type, XmlDocument xml) : this(type, new XmlDocument[] { xml }) { }