变更oracle访问组件

wzp

2023-03-02 374ce4ffd0c459bb4067e8d5765f972668aff9b1

 web/web/gwspupdate.aspx.cs

@@ -12,8 +12,12 @@
{
    protected List<GwAp> ApList;
    protected List<GwOp> OpList;
    protected List<GwProduct> GwProductList;

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


    public GwSp GwSp { get; protected set; }

@@ -37,6 +41,10 @@

    protected void Page_Load(object sender, EventArgs e)
    {
        _userId = this.AppContext.SessionObject.UserID;
        _userType = this.AppContext.SessionObject.UserType;
        _account = this.AppContext.SessionObject.Account;

        using (GwApDao gwApDao = new GwApDao())
            this.ApList = gwApDao.LoadInfoList();
        using (GwOpDao gwOpDao = new GwOpDao())
@@ -71,8 +79,31 @@
                this.GwSp.AccessCodeMode = 0;
                this.GwSp.ExtnoExtensionMode = 0;
                this.GwSp.CombinationMode = 0;

                this.GwSp.SubPackageNum = 4000;
                this.GwSp.SingleSubmitMinRestrict = 0;
                this.GwSp.IsDispalyPrice = 0;
                this.GwSp.DeductionMode = 1;
                this.GwSp.IsSendAudit = 0;
                this.GwSp.BelowNumAudit = 0;
                this.GwSp.AboveNumAudit = 0;
                this.GwSp.IsCumulativeAudit = 0;
                this.GwSp.CumulativeAuditNum = 0;
                this.GwSp.CumulativeAuditTime = 0;
                this.GwSp.IsSyncChildSendAudit = 0;
            }
        }

        //获取启用的产品分类
        using (GwProductDao gwProductDao = new GwProductDao())
        {
            GwProduct bean = new GwProduct();
            bean.Classes = 1;
            bean.IsDefault = -1;
            bean.IsEnable = -1;
            this.GwProductList = gwProductDao.getAllList(bean);
        }

    }

    public string McCount(int i, string mcExpression)
@@ -173,8 +204,9 @@
    {
        using (GwClientDao gwClientDao = new GwClientDao())
        {
            string permissionsSQL = gwClientDao.GetClientPermissions(_userId, _userType, null);
            string str = "";
            List<GwClient> list = gwClientDao.LoadInfoList("", "", "", "");
            List<GwClient> list = gwClientDao.LoadInfoList("", "", "", "", permissionsSQL);
            if (list.Count == 0)
            {
                str += string.Format("<option value=\"\">尚未创建客户信息</option>");
@@ -182,7 +214,7 @@
            else
            {
                foreach (GwClient gwClient in list)
                    str = !(clientId == gwClient.ClientID) ? str + string.Format("<option value=\"{0}\">{0}-{1}</option>", (object)gwClient.ClientID, (object)gwClient.ClientName) : str + string.Format("<option value=\"{0}\" selected>{0}-{1}</option>", (object)gwClient.ClientID, (object)gwClient.ClientName);
                    str = !(clientId == gwClient.ClientID) ? str + string.Format("<option value=\"{0}\">{1}</option>", (object)gwClient.ClientID, (object)gwClient.ClientID) : str + string.Format("<option value=\"{0}\" selected>{1}</option>", (object)gwClient.ClientID, (object)gwClient.ClientID);
            }
            return str;
        }
@@ -213,4 +245,36 @@
            return num;
        }
    }


    //获取产品信息
    public string GetProductOptions(string productId)
    {
        if (productId==null)
            return "<option value='0'>无</option>";
        StringBuilder stringBuilder = new StringBuilder();
        if (this.GwProductList.Count == 0)
            return "<option value='0'>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)"", (object)"无");
        foreach (GwProduct bean in this.GwProductList)
        {
            //停用的产品分类不再显示
            if (bean.IsEnable == 0)
            {
                continue;
            }
            //类别为产品不再显示
            if (bean.Classes == 0)
            {
                continue;
            }

            if (productId.Equals(bean.Id))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.Id, (object)bean.Name);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.Id, (object)bean.Name);
        }
        return stringBuilder.ToString();
    }

}