protected void Btngenerate_Click(object sender, EventArgs e)
{
cateselect = Label1.Text;
string supcode = "";
foreach (ListItem i in selecteditem)
{
supcode += "'" + i.Text + "',";
}
string resultsupplier = supcode.Substring(0, supcode.Length - 1);
string que = " select c.category,d.suppliercode,Month(d.deliverydate) as reordermonth,YEAR(d.deliverydate) as reorderyear, sum(b.cost) as reorderammount from OrderItem b,Item c ,sorder d "
+
"where b.itemcode = c.itemcode and d.purchaseordernumber = b.purchaseordernumber and c.category='"
+ cateselect +
"' and d.suppliercode in ("
+ resultsupplier
+ ") and d.deliverydate like ('"
+ time1
+ "-%' )"
+
"group by d.suppliercode, c.category, Month(d.deliverydate), YEAR(d.deliverydate)"
+ "union"
+ " select c.category,d.suppliercode,Month(d.deliverydate) as reordermonth,YEAR(d.deliverydate) as reorderyear, sum(b.cost) as reorderammount from OrderItem b,Item c ,sorder d "
+
"where b.itemcode = c.itemcode and d.purchaseordernumber = b.purchaseordernumber and c.category='"
+ cateselect +
"' and d.suppliercode in ("
+ resultsupplier
+ ") and d.deliverydate like ('"
+ time2
+ "-%' )"
+
"group by d.suppliercode, c.category, Month(d.deliverydate), YEAR(d.deliverydate)"
+ "union"
+ " select c.category,d.suppliercode,Month(d.deliverydate) as reordermonth,YEAR(d.deliverydate) as reorderyear, sum(b.cost) as reorderammount from OrderItem b,Item c ,sorder d "
+
"where b.itemcode = c.itemcode and d.purchaseordernumber = b.purchaseordernumber and c.category='"
+ cateselect +
"' and d.suppliercode in ("
+ resultsupplier
+ ") and d.deliverydate like ('"
+ time3
+ "-%' )"
+
"group by d.suppliercode, c.category, Month(d.deliverydate), YEAR(d.deliverydate)"
;
SS.CryDataSet ds = ssmanager.setReorderDataSet(que);
SS.SSreorderTrend cryview2 = new SS.SSreorderTrend();
cryview2.SetDataSource(ds);
CrystalReportViewer1.ReportSource = cryview2;
}
protected void Page_Load(object sender, EventArgs e)
{
cate = ListBox5.SelectedValue.ToString();
time1 = Lbmonth1.Text;
time2 = Lbmonth2.Text;
time3 = Lbmonth3.Text;
cateselect = Label1.Text;
selecttime = Calendar1.SelectedDate;
selecteditem = new List <ListItem>();
foreach (ListItem item in CheckBoxList1.Items)
{
if (item.Selected)
{
selecteditem.Add(item);
}
}
if (cate == null)
{
Button1.Enabled = false;
}
if (selecttime == null)
{
Btnmonth1.Enabled = false;
Btnmonth2.Enabled = false;
Btnmonth3.Enabled = false;
}
if (cateselect == null || selecteditem == null || time1 == null)
{
Btngenerate.Enabled = false;
}
string que = " select c.category,d.suppliercode,Month(d.deliverydate) as reordermonth,YEAR(d.deliverydate) as reorderyear, sum(b.cost) as reorderammount from OrderItem b,Item c ,sorder d where b.itemcode = c.itemcode and d.purchaseordernumber = b.purchaseordernumber group by d.suppliercode, c.category, Month(d.deliverydate), YEAR(d.deliverydate)";
SS.CryDataSet ds = ssmanager.setReorderDataSet(que);
SS.SSreorderTrend cryview2 = new SS.SSreorderTrend();
cryview2.SetDataSource(ds);
CrystalReportViewer1.ReportSource = cryview2;
}
