protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Response.Expires = 0;
Response.AddHeader("pragma", "no-cache");
Response.AddHeader("cache-control", "private");
Response.CacheControl = "no-cache";
this.btnClose.OnClientClick = "window.close(); return false;";
SearchFlow flow = new SearchFlow();
PopupStockinReturnSearchData data = new PopupStockinReturnSearchData();
if (Request.QueryString["DOCTYPE"] != null)
{
data.DOCTYPE = Convert.ToDouble(Request.QueryString["DOCTYPE"].ToString() == "" ? "0" : Request.QueryString["DOCTYPE"].ToString());
}
if (Request.QueryString["CUSTOMER"] != null)
{
data.CUSTOMER = Convert.ToDouble(Request.QueryString["CUSTOMER"].ToString() == "" ? "0" : Request.QueryString["CUSTOMER"].ToString());
}
if (Request.QueryString["REFLOID"] != null)
{
data.REFLOID = Convert.ToDouble(Request.QueryString["REFLOID"].ToString() == "" ? "0" : Request.QueryString["REFLOID"].ToString());
}
this.grvItem.DataSource = flow.GetStockinReturnSearchList(data);
this.grvItem.DataBind();
}
}
public static DataTable GetStockinReturnSearchList(PopupStockinReturnSearchData data)
{
string where = "QTY > 0 AND CUSTOMER = " + data.CUSTOMER.ToString() + " ";
if (data.DOCTYPE != 0)
where += (where == "" ? "" : "AND ") + "DOCTYPE = " + data.DOCTYPE.ToString() + " ";
//if (data.CUSTOMER != 0)
// where += (where == "" ? "" : "AND ") + "CUSTOMER = " + data.CUSTOMER.ToString() + " ";
if (data.REFLOID != 0)
where += (where == "" ? "" : "AND ") + "REFLOID = " + data.REFLOID.ToString() + " ";
string sql = "SELECT PDLOID, PDNAME, LOTNO, QTY, UNAME, DOCCODE, DOCNAME, REFLOID ";
sql += "FROM V_RETURN_WAIT_LIST ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY PDNAME, DOCCODE DESC,LOTNO DESC";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetStockinReturnSearchList(PopupStockinReturnSearchData data)
{
return SearchDAL.GetStockinReturnSearchList(data);
}