private void LoadGrid(string DCNumber, string PONumber, string DealerCode)
{
DataTable dtParts = new DataTable();
DataSet ds = new DataSet();
DataSet dsParts = new DataSet();
SqlDataReader dr = null;
string mPONo = "";
string mDCNo = "";
if (PONumber == "")
{
mPONo = this.Session["PONumber"].ToString();
}
else
{
mPONo = PONumber;
}
//if (DCNumber == "")
//{
// mDCNo = this.Session["DCNumber"].ToString();
//}
//else
//{
// mDCNo = DCNumber;
//}
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@PONO", SqlDbType.Char, 10)
};
param[0].Value = this.Session["DealerCode"].ToString();
param[1].Value = mPONo;
myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr);
dtParts.Load(dr);
//ds = (DataSet)ViewState["ObjPOds"];
ds = (DataSet)this.Session["DCDataSet"];
ds.Tables["DCItems"].Rows.Clear();
if (dtParts.Rows.Count != 0)
{
foreach (DataRow dRow in dtParts.Rows)
{
SqlParameter[] paramPO_Parts =
{
new SqlParameter("@PONO", SqlDbType.Char, 10),
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@ItemCode", SqlDbType.Char, 10)
};
paramPO_Parts[0].Value = mPONo;
paramPO_Parts[1].Value = this.Session["DealerCode"].ToString();
paramPO_Parts[2].Value = dRow["ItemCode"].ToString();
dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo", paramPO_Parts);
DataRow row = ds.Tables["DCItems"].NewRow();
row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1;
row["PartItemNo"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "PartItemNo", "Item");
row["PartItemName"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "ItemDesc", "Item");
row["unit"] = myFunc.GetStringValuesAgainstCodes("UnitCode='" + dRow["UnitCode"].ToString() + "'", "unit", "UnitDesc");
row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString();
row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
if (DCNumber == "")
{
row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
}
else
{
row["DCQuantity"] = myFunc.GetDCQty(DCNumber, dRow["ItemCode"].ToString());
}
row["Selected"] = true;
ds.Tables["DCItems"].Rows.Add(row);
}
//if (GridViewDC.VisibleRowCount > 0)
//{
// CheckBox chkSelect;
// TextBox txtDCQty;
// Label lblBalQty;
// foreach (GridViewRow gvr in GridViewDC.Rows)
// {
// chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect");
// txtDCQty = (TextBox)gvr.Cells[6].FindControl("txtDCQuantity");
// lblBalQty = (Label)gvr.Cells[5].FindControl("LbBalanceQuantity");
// chkSelect.Checked = true;
// txtDCQty.Text = lblBalQty.Text;
// //chkSelect.Enabled = false;
// }
//}
//txtVendorNo.Text = dsVendorInfo.Tables[0].Rows[0]["vendorCode"].ToString();
//txtVendorDesc.Text = dsVendorInfo.Tables[0].Rows[0]["vendorDesc"].ToString();
}
Session["DCDataSet"] = ds;
GridViewDC.DataSource = ds.Tables["DCItems"];
GridViewDC.DataSourceID = null;
GridViewDC.DataBind();
}
catch (Exception ex)
{
//ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo);
}
}
