private SupplierSearchData GetSearchData() { SupplierSearchData supData = new SupplierSearchData(); supData.CODE = txtSupCode.Text.Trim(); supData.SUPPLIERNAME = txtSupName.Text.Trim(); return supData; }
public ArrayList GetSearchSupplier(SupplierSearchData supData) { ArrayList arrResult = new ArrayList(); string whStr = ""; string sql = ""; whStr += (supData.CODE == "" ? "" : " S.CODE = '" + supData.CODE + "'"); whStr += (supData.SUPPLIERNAME == "" ? "" : (whStr == "" ? "" : " AND ") + " UPPER(S.SUPPLIERNAME) LIKE UPPER('%" + supData.SUPPLIERNAME + "%')"); sql = "SELECT S.LOID, S.CODE, S.SUPPLIERNAME, S.TAXID, T.NAME || S.CNAME || ' ' || S.CLASTNAME AS CONNAME, S.TEL"; sql += " FROM SUPPLIER S LEFT JOIN TITLE T ON S.CTITLE = T.LOID"; sql += (whStr == "" ? "" : " WHERE" + whStr); sql += " ORDER BY S.SUPPLIERNAME"; try { OracleDataReader zRd = OracleDB.ExecQueryCmd(sql); arrResult.Clear(); int i = 1; while (zRd.Read()) { SupplierResultData irData = new SupplierResultData(); irData.ORDERNO = i; irData.LOID = zRd["LOID"].ToString(); irData.CODE = zRd["CODE"].ToString(); irData.SUPPLIERNAME = zRd["SUPPLIERNAME"].ToString(); irData.TAXID = zRd["TAXID"].ToString(); irData.CNAME = zRd["CONNAME"].ToString(); irData.TEL = zRd["TEL"].ToString(); arrResult.Add(irData); i += 1; } } catch (Exception ex) { throw ex; } return arrResult; }