变更oracle访问组件

wzp

2023-03-02 374ce4ffd0c459bb4067e8d5765f972668aff9b1

 web/web/GwStatis.aspx.cs

@@ -17,7 +17,11 @@
    private List<GwClient> ClientList;
    private List<GwAp> ApList;

   
    private int _userId = -1;
    private string _userType = "";
    private string _account = "";
    string permissionsSQL = null;


    public StatisOption SelectedOptions { get; set; }

@@ -38,10 +42,18 @@
    protected void Page_Load(object sender, EventArgs e)
    {
        this.CheckRight("502", FailedOperation.ErrorMsgOnly);

        _userId = this.AppContext.SessionObject.UserID;
        _userType = this.AppContext.SessionObject.UserType;
        _account = this.AppContext.SessionObject.Account;
        permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null);

        using (GwOpDao gwOpDao = new GwOpDao())
            this.OpList = gwOpDao.LoadInfoList();
        using (GwClientDao gwClientDao = new GwClientDao())
            this.ClientList = gwClientDao.LoadInfoList("", "", "", "");
        {
            this.ClientList = gwClientDao.LoadInfoList("", "", "", "", permissionsSQL);
        }
        using (GwApDao gwApDao = new GwApDao())
            this.ApList = gwApDao.LoadInfoList();
        if (this.IsPostBack)
@@ -136,7 +148,7 @@
            foreach (GwClient gwClient in this.ClientList)
            {
                if (this.AppContext.HasRight("502"))
                    stringBuilder.AppendFormat("<option value=\"{0}\" {2}>{0}-{1}</option>", (object)gwClient.ClientID, (object)gwClient.ClientName, gwClient.ClientID == this.SelectedClientID ? (object)"selected" : (object)"");
                    stringBuilder.AppendFormat("<option value=\"{0}\" {2}>{0}-{1}</option>", (object)gwClient.ClientID, (object)gwClient.Company, gwClient.ClientID == this.SelectedClientID ? (object)"selected" : (object)"");
            }
        }
        return stringBuilder.ToString();
@@ -147,7 +159,7 @@
        StringBuilder stringBuilder = new StringBuilder();
        using (GwSpDao gwSpDao = new GwSpDao())
        {
            List<GwSp> list = gwSpDao.LoadInfoList("", "", "");
            List<GwSp> list = gwSpDao.LoadInfoList("", "", "", permissionsSQL);
            if (list.Count == 0)
            {
                stringBuilder.Append("<option value=\"\">暂无客户信息</option>");