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