| | |
| | | /// <param name="supportStaff">归属客服人员</param> |
| | | /// <param name="productId">产品ID</param> |
| | | /// <returns></returns> |
| | | //public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telphone, string agent) |
| | | public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telephone, string agent, string company, string salesman, string supportStaff, string productId, int isEnable,int isSub, string permissionsSQL ) |
| | | { |
| | | |
| | |
| | | { |
| | | oracleParameterArray[8] = new OracleParameter(":CLIENT_PARENTID", OracleDbType.Int32); |
| | | ((DbParameter)oracleParameterArray[8]).Value = (object)(isSub); |
| | | stringBuilder.Append(" and gwc.CLIENT_PARENTID != :CLIENT_PARENTID"); |
| | | stringBuilder.Append(" and gwc.CLIENT_PARENTID != 0"); |
| | | } |
| | | |
| | | |
| | |
| | | o.SupportStaff = oracleReaderWrapper.GetString("SUPPORT_STAFF", ""); |
| | | o.FinancialStaff = oracleReaderWrapper.GetString("FINANCIAL_STAFF", ""); |
| | | o.ChargeType = oracleReaderWrapper.GetInt("CHARGE_TYPE", 0); |
| | | o.SmsBillType = oracleReaderWrapper.GetInt("SMS_BILLTYPE",0); |
| | | o.SmsStatusReport = oracleReaderWrapper.GetInt("SMS_STATUS_REPORT", 0); |
| | | o.MmsStatusReport = oracleReaderWrapper.GetInt("MMS_STATUS_REPORT", 0); |
| | | |