产品分配账户

yzh

2021-10-11 6c4ea53f92500f49959013c36b5c67fed25cd791

 web/Dao/GwClientDao.cs

@@ -24,7 +24,7 @@
        /// <param name="telphone">联系电话</param>
        /// <param name="agent">业务员</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 company, string clientName, string telphone, string agent)
        {

            List<GwClient> list = new List<GwClient>();
@@ -39,6 +39,12 @@
                    oracleParameterArray[0] = new OracleParameter(":ClientID", (OracleDbType)126);
                    ((DbParameter)oracleParameterArray[0]).Value = (object)('%' + clientID + '%');
                    stringBuilder.Append(" and CLIENT_ID like :ClientID");
                }
                if (company != null && company != "")
                {
                    oracleParameterArray[1] = new OracleParameter(":Company", (OracleDbType)126);
                    ((DbParameter)oracleParameterArray[1]).Value = (object)('%' + company + '%');
                    stringBuilder.Append(" and Company like :Company");
                }
                if (clientName != null && clientName != "")
                {
@@ -167,7 +173,7 @@

        public bool Add(GwClient item)
        {
            return OracleHelper.ExecuteSql("INSERT INTO GW_CLIENT(CLIENT_ID,CLIENT_NAME,TELEPHONE,ADDRESS,AGENT,COMPANY,REMARK,PASSWORD,PERMISSION_DATA,CREATE_TIME,PARENTID) VALUES(:CLIENTID,:CLIENTNAME,:TELEPHONE,:ADDRESS,:AGENT,:COMPANY,:REMARK,:PASSWORD,:PERMISSION_DATA,SYSDATE,:PARENTID)", OracleHelper.Connection, new OracleParameter(":CLIENTID", (object)item.ClientID), new OracleParameter(":CLIENTNAME", (object)item.ClientName), new OracleParameter(":TELEPHONE", (object)item.Telephone), new OracleParameter(":ADDRESS", (object)item.Address), new OracleParameter(":AGENT", (object)item.Agent), new OracleParameter(":COMPANY", (object)item.Company), new OracleParameter(":REMARK", (object)item.Remark), new OracleParameter(":PASSWORD", (object)item.Password), new OracleParameter(":PERMISSION_DATA", (object)item.PermissionData), new OracleParameter(":PARENTID", (object)item.ParentId)) > 0;
            return OracleHelper.ExecuteSql("INSERT INTO GW_CLIENT(CLIENT_ID,CLIENT_NAME,TELEPHONE,ADDRESS,AGENT,COMPANY,REMARK,PASSWORD,PERMISSION_DATA,CREATE_TIME,PARENTID,Certification_Status) VALUES(:CLIENTID,:CLIENTNAME,:TELEPHONE,:ADDRESS,:AGENT,:COMPANY,:REMARK,:PASSWORD,:PERMISSION_DATA,SYSDATE,:PARENTID,:Certification_Status)", OracleHelper.Connection, new OracleParameter(":CLIENTID", (object)item.ClientID), new OracleParameter(":CLIENTNAME", (object)item.ClientName), new OracleParameter(":TELEPHONE", (object)item.Telephone), new OracleParameter(":ADDRESS", (object)item.Address), new OracleParameter(":AGENT", (object)item.Agent), new OracleParameter(":COMPANY", (object)item.Company), new OracleParameter(":REMARK", (object)item.Remark), new OracleParameter(":PASSWORD", (object)item.Password), new OracleParameter(":PERMISSION_DATA", (object)item.PermissionData), new OracleParameter(":PARENTID", (object)item.ParentId), new OracleParameter(":Certification_Status", (object)item.Certification_Status)) > 0;
        }

        public GwClient Get(string clientID)
@@ -217,6 +223,11 @@
            return list;
        }

        /// <summary>
        /// 判断账户是否存在
        /// </summary>
        /// <param name="clientID">账户</param>
        /// <returns></returns>
        public bool IsIDExists(string clientID)
        {
            if (string.IsNullOrEmpty(clientID) || string.Equals("0", clientID))
@@ -263,6 +274,13 @@
            o.BalanceThreshold = oracleReaderWrapper.GetInt("BALANCE_THRESHOLD", 0);
            o.PermissionData = oracleReaderWrapper.GetString("PERMISSION_DATA", "");
            o.Id = oracleReaderWrapper.GetInt("ID", 0);
            o.Certification_Status = oracleReaderWrapper.GetInt("CERTIFICATION_STATUS", 0);
            o.Client_Classes = oracleReaderWrapper.GetInt("CLIENT_CLASSES",0);
            o.Client_Parentid = oracleReaderWrapper.GetString("CLIENT_PARENTID", "");
            o.Client_Type = oracleReaderWrapper.GetInt("CLIENT_TYPE", 0);
            o.Is_Enable = oracleReaderWrapper.GetInt("IS_ENABLE", 0);
            o.Top_up_Amount_Total = (decimal)oracleReaderWrapper.GetInt("TOP_UP_AMOUNT_TOTAL", 0);
            o.Salesman = oracleReaderWrapper.GetString("SALESMAN", "");
            return true;
        }

@@ -319,6 +337,7 @@
            }
            return true;
        }

    }
}