Пример #1
0
 public void GetRequisition()
 {
     try
     {
         int POId = Convert.ToInt32(Request.QueryString["Id"]);
         DSdtls = Obj_StockMasterReport.GetStockForPrint(POId, out StrError);
         if (DSdtls.Tables.Count > 0)
         {
             if (DSdtls.Tables[0].Rows.Count > 0)
             {
                 lblStockNo.Text   = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["StockNo"].ToString());
                 lblStockDate.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["StockDate"].ToString());
                 lblRefNo.Text     = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["Refno"].ToString());
                 lblfrom.Text      = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequestFrom"].ToString());
                 LblPrepareBy.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
                 LblIssusedBy.Text = obj_Comman.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
             }
             if (DSdtls.Tables[1].Rows.Count > 0)
             {
                 ReqGrid.DataSource = DSdtls.Tables[1];
                 ReqGrid.DataBind();
             }
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
 public void GetRequisition()
 {
     try
     {
         int POId = Convert.ToInt32(Request.QueryString["Id"]);
         DSdtls = obj_RequisitionCafeteria.BindForReport(POId, out StrError);
         ViewState["ImportExel"] = DSdtls.Tables[1];
         if (DSdtls.Tables.Count > 0)
         {
             if (DSdtls.Tables[0].Rows.Count > 0)
             {
                 lblReqNo.Text   = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequisitionNo"].ToString());
                 lblReqDate.Text = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["RequisitionDate"].ToString());
                 lblEmp.Text     = Obj_Comm.ToTitleCase(DSdtls.Tables[0].Rows[0]["UserName"].ToString());
             }
             if (DSdtls.Tables[1].Rows.Count > 0)
             {
                 ReqGrid.DataSource = DSdtls.Tables[1];
                 ReqGrid.DataBind();
             }
         }
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }