protected void Page_Load(object sender, EventArgs e)
{
using (var db = Database.SPBase())
{
Label1.Text = db.RepLng.First(w => w.RepId == 4 && w.LangId == 2).Name;
var wh = db.Warehouse.Where(w => w.UserAccessWh.Any(a => a.UserId == 0)).Select(s => new { WId = s.WId.ToString(), s.Name, s.Def }).ToList();
WhComboBox.DataSource = new List <WhComboBoxItem>()
{
new WhComboBoxItem {
WId = "*", Name = "Усі"
}
}.Concat(wh.Select(s => new WhComboBoxItem
{
WId = s.WId,
Name = s.Name
}).ToList());
WhComboBox.DataBind();
GrpComboBox.DataSource = new List <GrpComboBoxItem>()
{
new GrpComboBoxItem {
GrpId = 0, Name = "Усі"
}
}.Concat(db.MatGroup.Where(w => w.Deleted == 0).Select(s => new GrpComboBoxItem {
GrpId = s.GrpId, Name = s.Name
}).ToList());
GrpComboBox.DataBind();
var k_list = new List <KagentComboBoxItem>()
{
new KagentComboBoxItem {
KaId = 0, Name = "Усі"
}
}.Concat(db.Kagent.Where(w => w.Deleted == 0 && (!w.Archived.HasValue || w.Archived == 0)).OrderBy(o => o.Name).Select(s => new KagentComboBoxItem {
KaId = s.KaId, Name = s.Name
})).ToList();
KagentComboBox.DataSource = k_list;
KagentComboBox.DataBind();
if (!IsPostBack)
{
StartDateEdit.Date = DateTime.Now.Date.AddDays(-1);
EndDateEdit.Date = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59);
WhComboBox.Value = "*";
GrpComboBox.Value = 0;
KagentComboBox.Value = 0;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db = Database.SPBase())
{
Label1.Text = db.RepLng.First(w => w.RepId == 7 && w.LangId == 2).Name;
var wh = db.Warehouse.Where(w => w.UserAccessWh.Any(a => a.UserId == 0)).Select(s => new { WId = s.WId.ToString(), s.Name, s.Def }).ToList();
WhComboBox.DataSource = new List <WhComboBoxItem>()
{
new WhComboBoxItem {
WId = "*", Name = "Усі"
}
}.Concat(wh.Select(s => new WhComboBoxItem
{
WId = s.WId,
Name = s.Name
}).ToList());
WhComboBox.DataBind();
GrpComboBox.DataSource = new List <GrpComboBoxItem>()
{
new GrpComboBoxItem {
GrpId = 0, Name = "Усі"
}
}.Concat(db.MatGroup.Where(w => w.Deleted == 0).Select(s => new GrpComboBoxItem {
GrpId = s.GrpId, Name = s.Name
}).ToList());
GrpComboBox.DataBind();
}
if (!IsPostBack)
{
OnDateDBEdit.Date = DateTime.Now;
WhComboBox.Value = "*";
GrpComboBox.Value = 0;
}
}
private void OkButton_Click(object sender, EventArgs e)
{
String str = "";
if (checkEdit2.Checked)
{
str += "1";
}
if (checkEdit1.Checked)
{
str += ",5";
}
if (checkEdit3.Checked)
{
str += ",6";
}
if (checkEdit4.Checked)
{
str += ",-1";
}
if (checkEdit5.Checked)
{
str += ",-6";
}
if (checkEdit6.Checked)
{
str += ",-5";
}
if (checkEdit7.Checked)
{
str += ",-20";
}
if (checkEdit8.Checked)
{
str += ",-22";
}
if (checkEdit9.Checked)
{
str += ",-24";
}
SetDate();
int grp = ChildGroupCheckEdit.Checked ? Convert.ToInt32((GrpComboBox.GetSelectedDataRow() as dynamic).GrpId) : 0;
/* var pr = new PrintReport
* {
* OnDate = OnDateDBEdit.DateTime,
* StartDate = StartDateEdit.DateTime,
* EndDate = EndDateEdit.DateTime,
* MatGroup = GrpComboBox.GetSelectedDataRow(),
* Kagent = KagentComboBox.GetSelectedDataRow(),
* Warehouse = WhComboBox.GetSelectedDataRow(),
* Material = MatComboBox.GetSelectedDataRow(),
* DocStr = str,
* DocType = DocTypeEdit.EditValue,
* ChType = ChTypeEdit.GetSelectedDataRow(),
* Status = wbStatusList.EditValue,
* KontragentGroup = GrpKagentLookUpEdit.GetSelectedDataRow(),
* GrpStr = ChildGroupCheckEdit.Checked ? String.Join(",", new BaseEntities().GetMatGroupTree(grp).ToList().Select(s => Convert.ToString(s.GrpId))) : "",
* Person = PersonLookUpEdit.GetSelectedDataRow()
* };
*
* pr.CreateReport(_rep_id);*/
var pr2 = new PrintReportv2(_rep_id, DBHelper.CurrentUser.KaId, DBHelper.CurrentUser.UserId)
{
OnDate = OnDateDBEdit.DateTime,
StartDate = StartDateEdit.DateTime,
EndDate = EndDateEdit.DateTime,
MatGroup = GrpComboBox.GetSelectedDataRow() as GrpComboBoxItem,
Kagent = KagentComboBox.GetSelectedDataRow() as KagentComboBoxItem,
Warehouse = WhComboBox.GetSelectedDataRow() as WhComboBoxItem,
Material = MatComboBox.GetSelectedDataRow() as MatComboBoxItem,
DocStr = str,
DocType = DocTypeEdit.EditValue,
ChType = ChTypeEdit.GetSelectedDataRow() as ChTypeComboBoxItem,
Status = wbStatusList.EditValue,
KontragentGroup = GrpKagentLookUpEdit.GetSelectedDataRow() as GrpKagentComboBoxItem,
GrpStr = ChildGroupCheckEdit.Checked ? String.Join(",", new BaseEntities().GetMatGroupTree(grp).ToList().Select(s => Convert.ToString(s.GrpId))) : "",
Person = PersonLookUpEdit.GetSelectedDataRow()
};
var template_name = pr2.GetTemlate(_rep_id);
var template_file = Path.Combine(IHelper.template_path, template_name);
if (File.Exists(template_file))
{
var report_data = pr2.CreateReport(template_file, DBHelper.CurrentUser.ReportFormat);
if (report_data != null)
{
IHelper.ShowReport(report_data, template_name);
}
else
{
MessageBox.Show("За обраний період звіт не містить даних !");
}
}
else
{
MessageBox.Show("Шлях до шаблонів " + template_file + " не знайдено!");
}
}
