Пример #1
0
 protected void GRDOUTSTANDINGPO_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     try
     {
         switch (e.CommandName)
         {
         case ("Select"):
         {
             DataSet DSInwardDetails = new DataSet();
             StrCondition    = string.Empty;
             StrCondition    = " AND C.SuplierId=" + e.CommandArgument;
             DSInwardDetails = Obj_PO.GetPOForStatusReportOSSupplierItems(StrCondition, out StrError);
             if (DSInwardDetails.Tables.Count > 0 && DSInwardDetails.Tables[0].Rows.Count > 0)
             {
                 GRDSUPLIEROSREPORT.DataSource = DSInwardDetails.Tables[0];
                 GRDSUPLIEROSREPORT.DataBind();
                 MergeRows(GRDSUPLIEROSREPORT);
                 GRDSUPLIEROSREPORT.Visible = true;
             }
             else
             {
                 GRDSUPLIEROSREPORT.DataSource = null;
                 GRDSUPLIEROSREPORT.DataBind();
                 GRDSUPLIEROSREPORT.Visible = false;
             }
         }
         break;
         }
     }
     catch (Exception ex)
     {
     }
 }
Пример #2
0
    private void SetInitialRowGRDOUTSTANDINGITEM()
    {
        try
        {
            DataTable dt = new DataTable();
            DataRow   dr = null;

            dt.Columns.Add(new DataColumn("#", typeof(Int32)));
            dt.Columns.Add(new DataColumn("SuplierName", typeof(string)));
            dt.Columns.Add(new DataColumn("pono", typeof(string)));
            dt.Columns.Add(new DataColumn("ItemName", typeof(string)));
            dt.Columns.Add(new DataColumn("ItemDesc", typeof(string)));
            dt.Columns.Add(new DataColumn("RemarkForPo", typeof(string)));
            dt.Columns.Add(new DataColumn("Unit", typeof(string)));
            dt.Columns.Add(new DataColumn("sumpoqty", typeof(string)));
            dt.Columns.Add(new DataColumn("suminqty", typeof(string)));
            dt.Columns.Add(new DataColumn("BalanceQty", typeof(string)));
            dr = dt.NewRow();

            dr["#"]           = 0;
            dr["SuplierName"] = "";
            dr["pono"]        = "";
            dr["ItemName"]    = "";
            dr["ItemDesc"]    = "";
            dr["RemarkForPo"] = "";
            dr["Unit"]        = "";
            dr["sumpoqty"]    = "";
            dr["suminqty"]    = "";
            dr["BalanceQty"]  = "";
            dt.Rows.Add(dr);
            ViewState["CurrentTable"]     = dt;
            GRDSUPLIEROSREPORT.DataSource = dt;
            GRDSUPLIEROSREPORT.DataBind();
            dt = null;
            dr = null;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }