private void SearchData()
{
SearchFlow flow = new SearchFlow();
PopupStockinReturnData data = new PopupStockinReturnData();
data.CODEFROM = this.txtCodeFrom.Text.Trim();
data.CODETO = this.txtCodeTo.Text.Trim();
data.DATEFROM = this.ctlDateFrom.DateValue;
data.DATETO = this.ctlDateTo.DateValue;
data.CUSTOMERNAME = this.txtCustomerName.Text.Trim();
data.REFLOID = Convert.ToDouble(this.cmbRefType.SelectedValue);
this.grvStockinReturn.DataSource = flow.GetStockinReturnList(data);
this.grvStockinReturn.DataBind();
}
private void SearchData()
{
SearchFlow flow = new SearchFlow();
PopupStockinReturnData data = new PopupStockinReturnData();
data.BARCODE = this.txtBarcode.Text.Trim();
data.PRODUCTNAME = this.txtBarcode.Text.Trim();
data.DATEFROM = this.ctlDateFrom.DateValue;
data.DATETO = this.ctlDateTo.DateValue;
data.LOTNO = this.txtLot.Text.Trim();
this.grvItem.DataSource = flow.GetStockinReturnWHList(data);
this.grvItem.DataBind();
}
public static DataTable GetStockinReturnWHList(PopupStockinReturnData data)
{
string where = "";
if (data.LOTNO.Trim() != "")
where += (where == "" ? "" : "AND ") + "LOTNO >= '" + OracleDB.QRText(data.CODEFROM.Trim()).ToUpper() + "' ";
if (data.BARCODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "BARCODE <= '" + OracleDB.QRText(data.CODETO.Trim()).ToUpper() + "' ";
if (data.DATEFROM.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(REQDATE, 'DDMMYYYY') >= " + OracleDB.QRDate(data.DATEFROM) + " ";
if (data.DATETO.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(REQDATE, 'DDMMYYYY') <= " + OracleDB.QRDate(data.DATETO) + " ";
if (data.PRODUCTNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PRODUCTNAME) LIKE '%" + OracleDB.QRText(data.CUSTOMERNAME.Trim()).ToUpper() + "%' ";
if (data.REFLOID != 0)
where += (where == "" ? "" : "AND ") + "DOCTYPE = " + data.REFLOID.ToString() + " ";
string sql = "SELECT * ";
sql += "FROM V_MATERIAL_RETURN_POPUP_LIST ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY LOTNO ";
return OracleDB.ExecListCmd(sql);
}
public static DataTable GetStockinReturnList(PopupStockinReturnData data)
{
string where = "";
if (data.CODEFROM.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(DOCCODE) >= '" + OracleDB.QRText(data.CODEFROM.Trim()).ToUpper() + "' ";
if (data.CODETO.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(DOCCODE) <= '" + OracleDB.QRText(data.CODETO.Trim()).ToUpper() + "' ";
if (data.DATEFROM.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(DOCDATE, 'DDMMYYYY') >= " + OracleDB.QRDate(data.DATEFROM) + " ";
if (data.DATETO.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(DOCDATE, 'DDMMYYYY') <= " + OracleDB.QRDate(data.DATETO) + " ";
if (data.CUSTOMERNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CUSTOMERNAME) LIKE '%" + OracleDB.QRText(data.CUSTOMERNAME.Trim()).ToUpper() + "%' ";
if (data.REFLOID != 0)
where += (where == "" ? "" : "AND ") + "DOCTYPE = " + data.REFLOID.ToString() + " ";
string sql = "SELECT REFLOID, DOCCODE, DOCDATE, CUSTOMERNAME, CUSTOMER CUSTOMERLOID, DOCTYPE ";
sql += "FROM V_RETURN_WAIT_DOC ";
sql += (where == "" ? "" : "WHERE " + where);
sql += "ORDER BY DOCCODE ";
return OracleDB.ExecListCmd(sql);
}
public DataTable GetStockinReturnWHList(PopupStockinReturnData data)
{
return SearchDAL.GetStockinReturnWHList(data);
}
