private ControlStockSearchData GetSearchData() { ControlStockSearchData data = new ControlStockSearchData(); data.BARCODE = txtBarcode.Text.Trim(); data.BARCODETO = txtBarcodeTo.Text.Trim(); data.PRODUCTNAME = txtProductName.Text.Trim(); data.WAREHOUSE = Convert.ToDouble(this.txtWarehouse.Text).ToString(); return data; }
public ArrayList GetSearchProduct(ControlStockSearchData data) { ArrayList arrResult = new ArrayList(); string whStr = ""; string sql = ""; if (data.WAREHOUSE.Trim() != "") whStr += (data.WAREHOUSE == "" ? "" : " PM.WAREHOUSE = " + data.WAREHOUSE + ""); if (data.BARCODE.Trim() != "") whStr += (data.BARCODE == "" ? "" : (whStr == "" ? "" : " AND ") + " PD.BARCODE >= '" + data.BARCODE + "'"); if (data.BARCODETO.Trim() != "") whStr += (data.BARCODETO == "" ? "" : (whStr == "" ? "" : " AND ") + " PD.BARCODE <= '" + data.BARCODETO + "'"); if (data.PRODUCTNAME.Trim() != "") whStr += (data.PRODUCTNAME == "" ? "" : (whStr == "" ? "" : " AND ") + " UPPER(PD.NAME) LIKE UPPER('%" + data.PRODUCTNAME + "%')"); sql = "SELECT PD.BARCODE, PD.NAME, PM.LOID AS PDMINMAXLOID, PM.STANDARD, PM.MINIMUM, PM.MAXIMUM"; sql += " FROM PRODUCTMINMAX PM INNER JOIN PRODUCT PD ON PM.PRODUCT = PD.PRODUCTMASTER AND PD.ISDEFAULT = 'Y' "; sql += (whStr == "" ? "" : " WHERE" + whStr); sql += " ORDER BY PD.BARCODE"; try { OracleDataReader zRd = OracleDB.ExecQueryCmd(sql); arrResult.Clear(); int i = 1; while (zRd.Read()) { ControlStockResultData irData = new ControlStockResultData(); irData.ORDERNO = i; irData.PDMINMAXLOID = zRd["PDMINMAXLOID"].ToString(); irData.BARCODE = zRd["BARCODE"].ToString(); irData.PRODUCTNAME = zRd["NAME"].ToString(); irData.STANDARD = Convert.ToDouble(zRd["STANDARD"]).ToString("#,##0.00"); irData.MINIMUM = Convert.ToDouble(zRd["MINIMUM"]).ToString("#,##0.00"); irData.MAXIMUM = Convert.ToDouble(zRd["MAXIMUM"]).ToString("#,##0.00"); arrResult.Add(irData); i += 1; } } catch (Exception ex) { throw ex; } return arrResult; }