private void SeltoDG()
{
try
{
ClsBEPurDetails bedg = new ClsBEPurDetails();
string str = "Select SlNo,Mname,ItemName,BatchNo,ExpDate,ItemsPbox,TotalBox,FreeQty,NetQty,MRP,DiscPers,DiscAmt,Basicrate,VatPers,VatAmt,TransPers,Netcost,SellPrice,SellingMargin,SellingAmt,DummyRate,MRPValue,WPValue,MaxQty,MinQty,Units,Strength,AgsSubNet,Claim from T_PurDetails Where ID=" + cbxID.Text;
dgvPurchase.Rows.Clear();
con = new OleDbConnection(dbCon());
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
bedg.SlNo = dr.GetValue(0).ToString();
bedg.PrType = dr.GetValue(1).ToString();
bedg.ItemName = dr.GetValue(2).ToString();
bedg.BatchNo = dr.GetValue(3).ToString();
bedg.ExpDte = dr.GetValue(4).ToString();
bedg.Nounit = dr.GetValue(5).ToString();
bedg.TotUnit = dr.GetValue(6).ToString();
bedg.FreeQty = dr.GetValue(7).ToString();
bedg.NetQty = dr.GetValue(8).ToString();
bedg.Mrp = dr.GetValue(9).ToString();
bedg.DiscPers = dr.GetValue(10).ToString();
bedg.Discamt = dr.GetValue(11).ToString();
bedg.BasicRate = dr.GetValue(12).ToString();
bedg.VatPers = dr.GetValue(13).ToString();
bedg.VatAmt = dr.GetValue(14).ToString();
bedg.TransPers = dr.GetValue(15).ToString();
bedg.Netcost = dr.GetValue(16).ToString();
bedg.SellingPers = dr.GetValue(17).ToString();
bedg.SellingMargin = dr.GetValue(18).ToString();
bedg.SellingAmt = dr.GetValue(19).ToString();
bedg.DummyRate = dr.GetValue(20).ToString();
bedg.MrpValue = dr.GetValue(21).ToString();
bedg.WpValue = dr.GetValue(22).ToString();
bedg.Maxqty = dr.GetValue(23).ToString();
bedg.Minqty = dr.GetValue(24).ToString();
bedg.Units = dr.GetValue(25).ToString();
bedg.Tstrength = dr.GetValue(26).ToString();
//,bedg .Netcost ,bedg .DiscPers ,bedg .DiscAmtt ,bedg .TransPers
bedg.AgsSubNetTot = dr.GetValue(27).ToString();
bedg.ClaimAmount = dr.GetValue(28).ToString();
string[] strDg = new string[] { bedg.SlNo, bedg.PrType, bedg.ItemName, bedg.BatchNo, bedg.ExpDte, bedg.Nounit, bedg.TotUnit, bedg.FreeQty, bedg.NetQty, bedg.Mrp, bedg.DiscPers, bedg.Discamt, bedg.BasicRate, bedg.VatPers, bedg.VatAmt, bedg.TransPers, bedg.Netcost, bedg.SellingPers, bedg.SellingMargin, bedg.SellingAmt, bedg.DummyRate, bedg.MrpValue, bedg.WpValue, bedg.Maxqty, bedg.Minqty, bedg.Units, bedg.Tstrength,bedg.AgsSubNetTot ,bedg.ClaimAmount };
dgvPurchase.Rows.Add(strDg);
}
dr.Close();
con.Close();
}
catch
{
}
}
{
try
{
ClsBEPurDetails bedg = new ClsBEPurDetails();
string str = "Select SlNo,Mname,ItemName,BatchNo,ExpDate,ItemsPbox,TotalBox,FreeQty,NetQty,MRP,DiscPers,DiscAmt,Basicrate,VatPers,VatAmt,TransPers,Netcost,SellPrice,SellingMargin,SellingAmt,DummyRate,MRPValue,WPValue,MaxQty,MinQty,Units,Strength,AgsSubNet,Claim from T_PurDetails Where ID=" + cbxID.Text;
dgvPurchase.Rows.Clear();
con = new OleDbConnection(dbCon());
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
bedg.SlNo = dr.GetValue(0).ToString();
bedg.PrType = dr.GetValue(1).ToString();
bedg.ItemName = dr.GetValue(2).ToString();
bedg.BatchNo = dr.GetValue(3).ToString();
bedg.ExpDte = dr.GetValue(4).ToString();
bedg.Nounit = dr.GetValue(5).ToString();
bedg.TotUnit = dr.GetValue(6).ToString();
bedg.FreeQty = dr.GetValue(7).ToString();
bedg.NetQty = dr.GetValue(8).ToString();
bedg.Mrp = dr.GetValue(9).ToString();
bedg.DiscPers = dr.GetValue(10).ToString();
bedg.Discamt = dr.GetValue(11).ToString();
bedg.BasicRate = dr.GetValue(12).ToString();
bedg.VatPers = dr.GetValue(13).ToString();
bedg.VatAmt = dr.GetValue(14).ToString();
bedg.TransPers = dr.GetValue(15).ToString();
bedg.Netcost = dr.GetValue(16).ToString();
bedg.SellingPers = dr.GetValue(17).ToString();
bedg.SellingMargin = dr.GetValue(18).ToString();
bedg.SellingAmt = dr.GetValue(19).ToString();
bedg.DummyRate = dr.GetValue(20).ToString();
bedg.MrpValue = dr.GetValue(21).ToString();
bedg.WpValue = dr.GetValue(22).ToString();
bedg.Maxqty = dr.GetValue(23).ToString();
bedg.Minqty = dr.GetValue(24).ToString();
bedg.Units = dr.GetValue(25).ToString();
bedg.Tstrength = dr.GetValue(26).ToString();
//,bedg .Netcost ,bedg .DiscPers ,bedg .DiscAmtt ,bedg .TransPers
bedg.AgsSubNetTot = dr.GetValue(27).ToString();
bedg.ClaimAmount = dr.GetValue(28).ToString();
string[] strDg = new string[] { bedg.SlNo, bedg.PrType, bedg.ItemName, bedg.BatchNo, bedg.ExpDte, bedg.Nounit, bedg.TotUnit, bedg.FreeQty, bedg.NetQty, bedg.Mrp, bedg.DiscPers, bedg.Discamt, bedg.BasicRate, bedg.VatPers, bedg.VatAmt, bedg.TransPers, bedg.Netcost, bedg.SellingPers, bedg.SellingMargin, bedg.SellingAmt, bedg.DummyRate, bedg.MrpValue, bedg.WpValue, bedg.Maxqty, bedg.Minqty, bedg.Units, bedg.Tstrength,bedg.AgsSubNetTot ,bedg.ClaimAmount };
dgvPurchase.Rows.Add(strDg);
}
dr.Close();
con.Close();
}
catch
{
}
}
No comments:
Post a Comment