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); }