public ArrayList GetSearchCustomer(CustomerSearchData cusData) { ArrayList arrResult = new ArrayList(); string whStr = ""; string sql = ""; whStr += (cusData.CUSCODE == "" ? "" : " C.CODE = '" + cusData.CUSCODE + "'"); whStr += (cusData.CUSTYPE == "" ? "" : (whStr == "" ? "" : " AND ") + " C.CUSTOMERTYPE = '" + cusData.CUSTYPE + "'"); whStr += (cusData.CUSNAME == "" ? "" : (whStr == "" ? "" : " AND ") + " UPPER(C.NAME) LIKE UPPER('%" + cusData.CUSNAME + "%')"); whStr += (cusData.LASTNAME == "" ? "" : (whStr == "" ? "" : " AND " ) + " UPPER(C.LASTNAME) LIKE UPPER('%" + cusData.LASTNAME + "%')"); whStr += (cusData.MEMBERTYPE == 0 ? "" : (whStr == "" ? "" : " AND ") + " C.MEMBERTYPE = " + cusData.MEMBERTYPE.ToString() + ""); whStr += (cusData.PROVINCE == 0 ? "" : (whStr == "" ? "" : " AND ") + " C.BILLPROVINCE = " + cusData.PROVINCE.ToString() + ""); sql = "SELECT C.LOID, C.CODE, C.NAME || ' ' || C.LASTNAME AS CUSNAME, M.NAME AS MEMBERTYPE, C.CUSTOMERTYPE, C.EPDATE, C.PAYMENT"; sql += " FROM CUSTOMER C LEFT JOIN MEMBERTYPE M ON C.MEMBERTYPE = M.LOID"; sql += (whStr == "" ? "" : " WHERE" + whStr); sql += " ORDER BY C.CODE"; try { OracleDataReader zRd = OracleDB.ExecQueryCmd(sql); arrResult.Clear(); int i = 1; while (zRd.Read()) { CustomerResultData irData = new CustomerResultData(); irData.ORDERNO = i; irData.LOID = zRd["LOID"].ToString(); irData.CODE = zRd["CODE"].ToString(); irData.CUSNAME = zRd["CUSNAME"].ToString(); irData.MEMBERTYPE = zRd["MEMBERTYPE"].ToString(); if (zRd["CUSTOMERTYPE"].ToString() == Constz.CustomerType.Personal.Code) irData.CUSTOMERTYPE = Constz.CustomerType.Personal.Name; else if (zRd["CUSTOMERTYPE"].ToString() == Constz.CustomerType.Company.Code) irData.CUSTOMERTYPE = Constz.CustomerType.Company.Name; else if (zRd["CUSTOMERTYPE"].ToString() == Constz.CustomerType.Government.Code) irData.CUSTOMERTYPE = Constz.CustomerType.Government.Name; irData.EPDATE = Convert.ToDateTime(zRd["EPDATE"]).ToString(Constz.DateFormat); if (zRd["PAYMENT"].ToString() == Constz.Payment.Cash.Code) irData.PAYMENT = Constz.Payment.Cash.Name; else if (zRd["PAYMENT"].ToString() == Constz.Payment.CreditCard.Code) irData.PAYMENT = Constz.Payment.CreditCard.Name; else if (zRd["PAYMENT"].ToString() == Constz.Payment.Credit.Code) irData.PAYMENT = Constz.Payment.Credit.Name; arrResult.Add(irData); i += 1; } } catch(Exception ex) { throw ex; } return arrResult; }
private CustomerSearchData GetSearchData() { CustomerSearchData cusData = new CustomerSearchData(); cusData.CUSCODE = txtCusCode.Text.Trim(); cusData.CUSNAME = txtCusName.Text.Trim(); cusData.LASTNAME = txtLastName.Text.Trim(); if (radPersonal.Checked == true) cusData.CUSTYPE = Constz.CustomerType.Personal.Code; else if (radPrivate.Checked == true) cusData.CUSTYPE = Constz.CustomerType.Company.Code; else if (radOrganize.Checked == true) cusData.CUSTYPE = Constz.CustomerType.Government.Code; cusData.MEMBERTYPE = Convert.ToDouble(cmbMemberType.SelectedItem.Value); cusData.PROVINCE = Convert.ToDouble(cmbProvince.SelectedItem.Value); return cusData; }