//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 })
{
}
