protected void BindGvorder() { string strSelectCmd = @" select p.pCADId,b.ord_no,b.art_no,b.art_qty,b.byr_nm,b.bCADCons,p.pCADCons,b.bCADDia,p.pCADDia,b.bCADGsm,p.pCADGsm,p.cadApproved,p.cadCanceled from tblBookCAD b join tblProdCAD p on b.ord_no=p.ord_no and b.art_no=p.art_no where p.cadApproved is null and p.cadCanceled is null" ; SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn); //conn.Open(); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); Gvorder.DataSource = ds; Gvorder.DataBind(); int columncount = Gvorder.Rows[0].Cells.Count; Gvorder.Rows[0].Cells.Clear(); Gvorder.Rows[0].Cells.Add(new TableCell()); Gvorder.Rows[0].Cells[0].ColumnSpan = columncount; Gvorder.Rows[0].Cells[0].Text = "No Order has pending for approval"; } else { Gvorder.DataSource = ds; Gvorder.DataBind(); } }
protected void BindGvorder() { string strSelectCmd = " select * FROM View_PO_Buyer WHERE byr_nm = '" + ddbuyer.SelectedItem.Text + "' AND ActiveOrder='1' AND Po_ShipDate IS NULL AND TnAapproved IS NULL AND TnaCancle IS NULL AND TnaCreateDate IS NOT NULL order by TnaCreateDate DESC"; SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn); //conn.Open(); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); Gvorder.DataSource = ds; Gvorder.DataBind(); int columncount = Gvorder.Rows[0].Cells.Count; Gvorder.Rows[0].Cells.Clear(); Gvorder.Rows[0].Cells.Add(new TableCell()); Gvorder.Rows[0].Cells[0].ColumnSpan = columncount; Gvorder.Rows[0].Cells[0].Text = "No Order has pending for approval"; } else { Gvorder.DataSource = ds; Gvorder.DataBind(); } }
protected void BindGvorder() { conn.Open(); string strSelectCmd = "SELECT * FROM View_OrderInhand where ActiveOrder='1' AND PO_Ship_Date is NOT NULL AND po_xfactory Between '" + tx1.Text + "' and '" + tx2.Text + "' AND byr_nm = '" + ddlbuyerFind.SelectedItem.Text + "' order by po_xfactory ASC"; SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); Gvorder.DataSource = ds; Gvorder.DataBind(); int columncount = Gvorder.Rows[0].Cells.Count; Gvorder.Rows[0].Cells.Clear(); Gvorder.Rows[0].Cells.Add(new TableCell()); Gvorder.Rows[0].Cells[0].ColumnSpan = columncount; Gvorder.Rows[0].Cells[0].Text = "Note:-Please Select Buyer, Form Date and To Date. Then Click Find"; } else { //Search Option-RUS ViewState["dtOrder"] = ds.Tables[0]; //Search Option-RUS Gvorder.DataSource = ds; Gvorder.DataBind(); Gvorder.Attributes["style"] = "border-collapse:separate"; } }
//Search Option-RUS protected void btnSearch_Click(object sender, EventArgs e) { DataTable dtOrder = (DataTable)ViewState["dtOrder"]; DataView dvOrder = dtOrder.DefaultView; dvOrder.RowFilter = "ord_no like '" + txtSearch.Text + "%'"; Gvorder.DataSource = dvOrder; Gvorder.DataBind(); }
protected void BindGvorder() { conn.Open(); // string strSelectCmd = @"select distinct bt.byr_nm, om.ord_no,ft.Fact_nm,om.ord_cnfdate,pm.po_quantity,pm.po_price,pm.Totalprice,pm.po_xfactory,pm.ExportQty,pm.TnAapproved,pm.ActiveOrder, // om.ord_factory,pm.po_no,om.ord_entdt,gt.gmtyp,tt.PO_Ship_Date,pm.art_no // from Order_Master om --where ord_no='283190' // INNER JOIN Buyer_Tab bt ON om.ord_buyer = bt.byr_id // inner join Factory_Tab ft on om.ord_factory=ft.Fact_id // inner join PO_Master pm on om.ord_no=pm.ord_no and om.ord_buyer=pm.ord_buyer and om.ord_cnfdate=pm.ord_cnfdate and om.art_no=pm.art_no // inner join Tbl_TnaPlan tt on om.ord_no=tt.TnaOrdNm // inner join GarmentsType gt on om.grment_typ=gt.gmtid // where ActiveOrder='1' AND TnAapproved IS NOT NULL AND PO_Ship_Date is NULL AND po_xfactory Between '" + tx1.Text + "' and '" + tx2.Text + "' AND byr_nm = '" + ddlbuyerFind.SelectedItem.Text + "' order by po_xfactory ASC"; string strSelectCmd = @"select distinct bt.byr_nm, om.ord_no,ft.Fact_nm,om.ord_cnfdate,pm.po_quantity,pm.po_price,pm.Totalprice,tt.ReExFactory,pm.po_xfactory,pm.ExportQty,pm.TnAapproved,pm.ActiveOrder, om.ord_factory,pm.po_no,om.ord_entdt,gt.gmtyp,tt.PO_Ship_Date,pm.art_no,am.art_smv,(pm.po_quantity*am.art_smv) as TotalSmvQty from Order_Master om --where ord_no='283190' INNER JOIN Buyer_Tab bt ON om.ord_buyer = bt.byr_id inner join Factory_Tab ft on om.ord_factory=ft.Fact_id inner join PO_Master pm on om.ord_no=pm.ord_no and om.ord_buyer=pm.ord_buyer and om.ord_cnfdate=pm.ord_cnfdate and om.ord_entdt=pm.ord_entdt inner join Tbl_TnaPlan tt on om.ord_no=tt.TnaOrdNm and om.ord_buyer=tt.TnaByrNm and pm.ord_buyer=tt.TnaByrNm and pm.ord_no=tt.TnaOrdNm and pm.po_id=tt.TnaPoNm and pm.TnaCreateDate=tt.Tna_Cr_Date inner join GarmentsType gt on om.grment_typ=gt.gmtid inner join Article_Master am on pm.art_no=am.art_no and pm.ord_no=am.ord_no and tt.art_no=am.art_no and tt.TnaOrdNm=am.ord_no where ActiveOrder='1' AND TnAapproved IS NOT NULL AND PO_Ship_Date is NULL AND isnull(tt.ReExFactory,po_xfactory) Between '" + tx1.Text + "' and '" + tx2.Text + "' AND byr_nm = '" + ddlbuyerFind.SelectedItem.Text + "' order by po_xfactory ASC"; SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); Gvorder.DataSource = ds; Gvorder.DataBind(); int columncount = Gvorder.Rows[0].Cells.Count; Gvorder.Rows[0].Cells.Clear(); Gvorder.Rows[0].Cells.Add(new TableCell()); Gvorder.Rows[0].Cells[0].ColumnSpan = columncount; Gvorder.Rows[0].Cells[0].Text = "Note:-Please Select Buyer, Form Date and To Date. Then Click Find"; } else { //Search Option-RUS ViewState["dtOrder"] = ds.Tables[0]; //Search Option-RUS Gvorder.DataSource = ds; Gvorder.DataBind(); Gvorder.Attributes["style"] = "border-collapse:separate"; } }