public static ArrayList GetReturnSearch(string WHLoid,string SiCode, string DateFrom, string DateTo) { string str = ""; ArrayList arrResult = new ArrayList(); str = " SELECT SICODE, APPROVEDATE, CUSNAME, RQCODE, GRANDTOT, SILOID "; str += " FROM V_RETURN_LIST " ; str += " WHERE WAREHOUSE = " + WHLoid + " "; if (SiCode != "") { str += " AND UPPER(SICODE) = UPPER ('" + SiCode + "')"; } if (DateFrom != null && DateTo != null) { str += " AND APPROVEDATE BETWEEN TO_DATE('" + DateFrom + "','DD/MM/YYYY') AND TO_DATE('" + DateTo + "','DD/MM/YYYY')"; } try { OracleDataReader zRd = OracleDB.ExecQueryCmd(str); arrResult.Clear(); int i = 1; while (zRd.Read()) { ReturnSearchData irData = new ReturnSearchData(); irData.SICODE = zRd["SICODE"].ToString(); irData.APPROVEDATE = Convert.ToDateTime(zRd["APPROVEDATE"]); irData.CUSNAME = zRd["CUSNAME"].ToString(); irData.RQCODE = zRd["RQCODE"].ToString(); irData.GRANDTOT = Convert.ToDouble(zRd["GRANDTOT"]); irData.SILOID = Convert.ToDouble(zRd["SILOID"]); arrResult.Add(irData); i = i + 1; } } catch (Exception ex) { throw ex; } return arrResult; }
public static ArrayList GetReturnPopup(string WHLoid, string RQCODE_FROM, string RQCODE_TO, string DATEFROM, string DATETO,string CUSCODE, string PDLOID ) { string str = ""; ArrayList arrResult = new ArrayList(); str = " SELECT DISTINCT CODE RQCODE ,INVCODE, REQDATE, CFULLNAME "; str += " FROM V_INVRETURN_LIST "; str += " WHERE WAREHOUSE =" + WHLoid + ""; if ((RQCODE_FROM != "") && (RQCODE_TO != "")) str += " AND CODE BETWEEN '" + RQCODE_FROM + "' AND '" + RQCODE_TO + "'"; if ((DATEFROM != "") && (DATETO != "")) str += " AND TO_DATE(REQDATE,'DD/MM/YYYY') BETWEEN TO_DATE('" + DATEFROM + "','DD/MM/YYYY') AND TO_DATE('" + DATETO + "','DD/MM/YYYY')"; if (CUSCODE != "") str += " AND CCODE ='" + CUSCODE + "'"; if (PDLOID != "0") str += " AND PRODUCT =" + PDLOID + ""; try { OracleDataReader zRd = OracleDB.ExecQueryCmd(str); arrResult.Clear(); int i = 1; while (zRd.Read()) { ReturnSearchData irData = new ReturnSearchData(); irData.ORDERNO = i; irData.RQCODE = zRd["RQCODE"].ToString(); irData.INVCODE = zRd["INVCODE"].ToString(); irData.REQDATE = Convert.ToDateTime(zRd["REQDATE"]); irData.CUSNAME = zRd["CFULLNAME"].ToString(); arrResult.Add(irData); i = i + 1; } } catch (Exception ex) { throw ex; } return arrResult; }