Exemple #1
0
        private void BindAnnexure(Int64 billno)
        {
            AnnexureReportDAL obj = new AnnexureReportDAL();
            var lst = obj.selectannexureno(billno);

            obj = null;
            if (lst != null && lst.Count > 0)
            {
                ddlAnnexure.Enabled        = true;
                ddlAnnexure.DataSource     = lst;
                ddlAnnexure.DataTextField  = "Name";
                ddlAnnexure.DataValueField = "Value";
                ddlAnnexure.DataBind();
                ddlAnnexure.Items.Insert(0, new ListItem("--Select--", "0"));
            }
            if (lst == null && lst.Count == 0)
            {
                ddlAnnexure.DataSource = null;
                ddlAnnexure.DataBind();
                ddlAnnexure.Enabled = false;
            }
        }
Exemple #2
0
        private void BindGrid()
        {
            AnnexureReportDAL obj       = new AnnexureReportDAL();
            Int32             intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);

            if (string.IsNullOrEmpty(txtBillNo.Text.Trim()))
            {
                ShowMessageErr("Invoice No cannot be blank.");
            }
            else
            {
                DataTable list = obj.SelectRep("Annexure", txtBillNo.Text.Trim(), ddlAnnexure.SelectedValue, intyearid, conString);
                if ((list != null) && (list.Rows.Count > 0))
                {
                    if (PrintRpt() == true)
                    {
                        ViewState["CSVdt"] = list;
                        fillAnnexureRpt();
                        lnkbtnPrint.Visible = true;
                        imgBtnExcel.Visible = true;
                    }
                    ViewState["CSVdt"] = list;
                    grdMain.DataSource = list;
                    grdMain.DataBind();
                    lblTotalRecord.Text = "T. Record (s): " + list.Rows.Count;
                    lnkbtnPrint.Visible = true;
                    imgBtnExcel.Visible = true;
                }
                else
                {
                    grdMain.DataSource = null;
                    grdMain.DataBind();
                    ViewState["CSVdt"]  = null;
                    lblTotalRecord.Text = "Total Record (s): 0 ";
                    lnkbtnPrint.Visible = false;
                    imgBtnExcel.Visible = false;
                }
            }
        }