wzp
2023-03-02 adee7a71ba7ab1b63cab63381dfe1846437853d6
web/Dao/GwClientDao.cs
@@ -28,7 +28,6 @@
        /// <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 )
        {
@@ -108,7 +107,7 @@
                {
                    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");
                }
@@ -530,6 +529,7 @@
            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);