private void inv_detail() { if (Request.QueryString["inv"] != "" && Request.QueryString["inv"] != null) { bl.inv_no = Request.QueryString["inv"].ToString(); DataSet ds = new DataSet(); ds = dl.select_inv_detail(bl); if (ds.Tables[0].Rows.Count > 0) { lbl_odr_no.Text = ds.Tables[0].Rows[0]["po_no"].ToString(); lbl_odr_dt.Text = ds.Tables[0].Rows[0]["po_date"].ToString(); lbl_tt_qty.Text = ds.Tables[0].Rows[0]["total_qty"].ToString(); lbl_dc_no.Text = ds.Tables[0].Rows[0]["dc_no"].ToString(); lbl_dc_dt.Text = ds.Tables[0].Rows[0]["dc_date"].ToString(); lbl_vihical_no.Text = ds.Tables[0].Rows[0]["vehical_no"].ToString(); lbl_to.Text = ds.Tables[0].Rows[0]["to_"].ToString(); lbl_from.Text = ds.Tables[0].Rows[0]["from_s"].ToString(); lbl_deshpath.Text = ds.Tables[0].Rows[0]["transport_name"].ToString(); } } }
private void inv_detail() { if (Request.QueryString["inv"] != "" && Request.QueryString["inv"] != null) { bl.inv_no = Request.QueryString["inv"].ToString(); DataSet ds = new DataSet(); ds = dl.select_inv_detail(bl); if (ds.Tables[0].Rows.Count > 0) { lbl_vch_typ.Text = ds.Tables[0].Rows[0]["vch_nm"].ToString(); lbl_inv_no.Text = ds.Tables[0].Rows[0]["invoice_no"].ToString(); lbl_inv_dt.Text = ds.Tables[0].Rows[0]["invoice_date"].ToString(); lbl_odr_no.Text = ds.Tables[0].Rows[0]["po_no"].ToString(); lbl_odr_dt.Text = ds.Tables[0].Rows[0]["po_date"].ToString(); lbl_lr_no.Text = ds.Tables[0].Rows[0]["lr_no"].ToString(); lbl_lr_dt.Text = ds.Tables[0].Rows[0]["lr_date"].ToString(); lbl_dc_no.Text = ds.Tables[0].Rows[0]["dc_no"].ToString(); lbl_dc_dt.Text = ds.Tables[0].Rows[0]["dc_date"].ToString(); lbl_deshpath.Text = ds.Tables[0].Rows[0]["transport_name"].ToString(); //lbl_tt_qty.Text = ds.Tables[0].Rows[0]["total_qty"].ToString(); string amt = ds.Tables[0].Rows[0]["total"].ToString(); double a = Convert.ToDouble(amt); amt = string.Format("{0:0.00}", a); lbl_amt.Text = amt; lbl_vihical_no.Text = ds.Tables[0].Rows[0]["vehical_no"].ToString(); lbl_to.Text = ds.Tables[0].Rows[0]["to_"].ToString(); lbl_from.Text = ds.Tables[0].Rows[0]["from_s"].ToString(); lbl_ecc_comdity.Text = ds.Tables[0].Rows[0]["exci_como_no"].ToString(); lbl_tariff_no.Text = ds.Tables[0].Rows[0]["teriff_no"].ToString(); lbl_issu_dt.Text = ds.Tables[0].Rows[0]["invoice_date"].ToString(); lbl_issu_time.Text = ds.Tables[0].Rows[0]["inv_time"].ToString(); lbl_removal_dt.Text = ds.Tables[0].Rows[0]["removel_dt"].ToString(); lbl_reoval_time.Text = ds.Tables[0].Rows[0]["removal_time"].ToString(); string exc = ds.Tables[0].Rows[0]["exce"].ToString(); double pr = Convert.ToDouble(exc); ttl = 0; ttl = ttl + pr; exc = string.Format("{0:0.00}", pr); // lbl_price.Text = exc; if (ds.Tables[0].Rows[0]["disc"].ToString() != string.Empty && ds.Tables[0].Rows[0]["disc"].ToString() != "0") { lbl_extra.Text = "Discount</Br>"; double di = Convert.ToDouble(ds.Tables[0].Rows[0]["disc"].ToString()); string.Format("{0:0.00}", di); lbl_extraprice.Text = string.Format("{0:0.00}", di) + "</Br>"; } if (lbl_extra.Text != string.Empty) { lbl_extra.Text = lbl_extra.Text + "Excise 12.5% </Br>"; lbl_extraprice.Text = lbl_extraprice.Text + exc + "</Br>"; } else { lbl_extra.Text = "Excise 12.5% </Br>"; lbl_extraprice.Text = exc + "</Br>"; } lbl_vat_type.Text = ds.Tables[0].Rows[0]["vat_type"].ToString(); if (lbl_vat_type.Text == "vat @ 12.5%") { lbl_addvat.Text = "2.5%"; } else { lbl_addvat.Text = "1%"; } string vat = ds.Tables[0].Rows[0]["tax_4"].ToString(); double v = Convert.ToDouble(vat); vat = string.Format("{0:0.00}", v); lbl_vat_amt.Text = vat; string avat = ds.Tables[0].Rows[0]["vat_1"].ToString(); double av = Convert.ToDouble(avat); avat = string.Format("{0:0.00}", av); lbl_add_amt.Text = avat; lbl_pa.Text = ds.Tables[0].Rows[0]["pla"].ToString(); lbl_rg.Text = ds.Tables[0].Rows[0]["r_g"].ToString(); lbl_prt.Text = ds.Tables[0].Rows[0]["part"].ToString(); lbl_dt.Text = ds.Tables[0].Rows[0]["dt"].ToString(); string str = ds.Tables[0].Rows[0]["total_amount"].ToString(); double st = Convert.ToDouble(str); str = string.Format("{0:0.00}", st); lbl_net_amt.Text = str; double n = Convert.ToDouble(lbl_net_amt.Text); string s = Math.Round(n, 0).ToString(); double g = Convert.ToDouble(exc); string r = Math.Round(g, 0).ToString(); string word = ConvertNumbertoWords(Convert.ToInt32(n)); lblmsg.InnerText = word; string word2 = ConvertNumbertoWords(Convert.ToInt32(r)); lblmsg2.InnerText = word2; } } }