public void FillPro(string proid, string dat)
{
try
{
dt_ = new DataTable();
q = "select ProductID from Products where ProductType = '" + proid + "'";
dt_ = DBConnection.GetQueryData(q);
if (dt_.Rows.Count > 0)
{
proid = dt_.Rows[0]["ProductID"].ToString();
}
q = " select * from v_stk where Mstk_dat <= '" + dat + "' and ProductID ='" + proid
+ "' and returntyp not in ('Defected')";
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillPro(string proid, string dat)
{
try
{
//dt_ = new DataTable();
//q = "select ProductID from Products where ProductType = '" + proid + "'";
//dt_ = DBConnection.GetQueryData(q);
//if (dt_.Rows.Count > 0)
//{
// proid = dt_.Rows[0]["ProductID"].ToString();
//}
q = " select * from v_stockreport where ProductID ='" + proid
+ "' and returntyp not in ('Defected') and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'";
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillProcat(string protypid)
{
try
{
q = " select * from v_stk where ProductType ='" + protypid +
"' and returntyp not in ('Defected') and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
float GTotal = 0;
for (int k = 0; k < GVStk.Rows.Count; k++)
{
Label total = (Label)GVStk.Rows[k].FindControl("tb_stkval");
GTotal += Convert.ToSingle(total.Text);
}
lbl_ttlStkVal.Text = GTotal.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillProcat(string protypid)
{
try
{
q = " select * from v_stockreport where ProductType ='" + protypid +
"' and returntyp not in ('Defected') and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillProcat(string protypid)
{
try
{
q = " select * from v_stk where ProductType ='" + protypid +
"' and returntyp not in ('Defected')";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillGrid()
{
try
{
q = " select * from v_stockreport where Dstk_unt = '" + Siz + "' and returntyp not in ('Defected') and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillGrid(string rej, DateTime date)
{
try
{
q = " select * from v_stk where ProductID='" + rej + "' and returntyp='Defected' and dstkdef <> 0 and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillGrid()
{
try
{
q = " select * from v_stk where Dstk_unt = '" + Siz + "' and returntyp not in ('Defected')";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillGrid()
{
try
{
q = " select * from v_stk where Mstk_dat <= '" + dat + "' and returntyp='Defected'";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
public void FillGrid(string rej, DateTime date)
{
try
{
q = " select * from v_stk where Mstk_dat <= '" + date + "' and ProductID='" + rej + "' and returntyp='Defected' and dstkdef <> 0";
dt_ = new DataTable();
dt_ = DBConnection.GetQueryData(q);
GVStk.DataSource = dt_;
GVStk.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}