private void invpro()
{
try
{
bl.inv_no = Request.QueryString["inv"].ToString();;
DataSet ds2 = new DataSet();
ds2 = dl.select_inv_item_detail(bl);
if (ds2.Tables[0].Rows.Count > 0)
{
string pro = "";
string desc = "";
string qty = "";
string rate = "";
string per = "";
string amo = "";
string sr = "";
// string tax = "";
string dec = "";
// string no="";
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
sr = sr + (i + 1) + "</br>";
pro = pro + ds2.Tables[0].Rows[i]["item_name"].ToString() + "</br>";
desc = desc + ds2.Tables[0].Rows[i]["descr"].ToString() + "</br>";
qty = qty + ds2.Tables[0].Rows[i]["qty"].ToString() + "</br>";
// tax = tax + "</br>" + ds2.Tables[0].Rows[i]["tax"].ToString();
dec = dec + "</br>" + ds2.Tables[0].Rows[i]["disc"].ToString();
if (ds2.Tables[0].Rows[i]["rate"].ToString() == "")
{
rate = rate + "</br>" + ds2.Tables[0].Rows[i]["rate"].ToString();
}
else
{
rate = rate + "</br>" + ds2.Tables[0].Rows[i]["rate"].ToString() + ".00";
}
per = per + "</br>" + ds2.Tables[0].Rows[i]["per"].ToString();
if (ds2.Tables[0].Rows[i]["amount"].ToString() == "")
{
amo = amo + "</br>" + ds2.Tables[0].Rows[i]["amount"].ToString();
}
else
{
amo = amo + "</br>" + ds2.Tables[0].Rows[i]["amount"].ToString() + ".00";
}
}
// lbl_no.Text = no;
lbl_sr.Text = sr;
lbl_itm_nm.Text = pro;
lbl_qty.Text = qty;
}
}
catch
{
}
}
private void invpro()
{
try
{
bl.inv_no = Request.QueryString["inv"].ToString();
DataSet ds2 = new DataSet();
ds2 = dl.select_inv_item_detail(bl);
if (ds2.Tables[0].Rows.Count > 0)
{
string pro = "";
string desc = "";
string qty = "";
string rate = "";
string per = "";
string amo = "";
string sr = "";
// string tax = "";
string dec = "";
// string no="";
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
sr = sr + (i + 1) + "</br>";
pro = pro + ds2.Tables[0].Rows[i]["item_name"].ToString() + "</br>";
desc = desc + ds2.Tables[0].Rows[i]["descr"].ToString() + "</br>";
qty = qty + ds2.Tables[0].Rows[i]["qty"].ToString() + "</br>";
// tax = tax + "</br>" + ds2.Tables[0].Rows[i]["tax"].ToString();
if (ds2.Tables[0].Rows[i]["disc"].ToString() != string.Empty)
{
dec = dec + "</br>" + ds2.Tables[0].Rows[i]["disc"].ToString();
}
if (ds2.Tables[0].Rows[i]["rate"].ToString() == "")
{
rate = rate + ds2.Tables[0].Rows[i]["rate"].ToString() + "</br>";
}
else
{
string str = ds2.Tables[0].Rows[i]["rate"].ToString();
double st = Convert.ToDouble(str);
str = string.Format("{0:0.00}", st);
rate = rate + str + "</br>";
}
per = per + ds2.Tables[0].Rows[i]["per"].ToString() + "</br>";
if (ds2.Tables[0].Rows[i]["amount"].ToString() == "")
{
amo = amo + ds2.Tables[0].Rows[i]["amount"].ToString() + "</br>";
}
else
{
string str = ds2.Tables[0].Rows[i]["amount"].ToString();
double st = Convert.ToDouble(str);
str = string.Format("{0:0.00}", st);
amo = amo + str + "</br>";
}
}
// lbl_no.Text = no;
lbl_itm_nm.Text = pro;
;// double aqty = Convert.ToDouble(qty);
lbl_qty.Text = qty;
lbl_rt.Text = rate;
lbl_par.Text = per;
if (dec != string.Empty && dec != "0")
{
lbl_extra.Text = "Discount";
lbl_extraprice.Text = dec;
}// lbl_dis.Text = dec;
lbl_total_amt.Text = amo;
lbl_sr.Text = sr;
}
}
catch
{
}
}
