变更oracle访问组件

wzp

2023-03-02 374ce4ffd0c459bb4067e8d5765f972668aff9b1

 web/web/GwOrderList.aspx.cs

@@ -14,6 +14,8 @@

    protected List<GwProduct> GwProductList;
    protected List<GwClient> GwClientList;
    //返回URL
    public string backUrl = "";

    public string sDate
    {
@@ -37,10 +39,41 @@
        }
    }

    public string ClientId
    {
        get
        {
            if (!string.IsNullOrEmpty(this.AppContext.GetString("clientId")))
            {
                GwClient gwClient = new GwClient();
                using (GwClientDao gwClientDao = new GwClientDao())
                {
                    gwClient = gwClientDao.Get(this.AppContext.GetString("clientId") );

                    if (gwClient.Is_Enable == 1)
                    {
                        backUrl = "GwClient.aspx?IsEnable=1";
                    }
                    else
                    {
                        backUrl = "GwClient.aspx?IsEnable=0";
                    }
                }
            }

            return this.AppContext.GetString("clientId");
        }
    }

    public string SpID
    {
        get
        {
            if (!string.IsNullOrEmpty(this.AppContext.GetString("spId")))
            {
                backUrl = "GwSp.aspx";
            }

            return this.AppContext.GetString("spId");
        }
    }
@@ -80,9 +113,9 @@
            }

            if (productId.Equals(bean.Id))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.Id, (object)bean.Name);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.Id, (object)bean.Name);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.Id, (object)bean.Name);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.Id, (object)bean.Name);
        }
        return stringBuilder.ToString();
    }
@@ -97,10 +130,61 @@
        foreach (GwClient bean in this.GwClientList)
        {
            if (clientId.Equals(bean.ClientID))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.ClientID, (object)bean.ClientName);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.ClientID, (object)bean.Company);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.ClientID, (object)bean.ClientName);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.ClientID, (object)bean.Company);
        }
        return stringBuilder.ToString();
    }

    //产品ID转换名称
    public string ProductIdToName(string productId)
    {
        if (this.GwProductList.Count == 0)
            return productId;
        foreach (GwProduct bean in this.GwProductList)
        {
            if (productId.Equals(bean.Name))
                return bean.Name;
            else
                continue;
        }

        return productId;
    }

    //客户ID转换名称
    public string ClientIdToName(string clientId)
    {
        if (this.GwClientList.Count == 0)
            return clientId;
        foreach (GwClient bean in this.GwClientList)
        {
            if (clientId.Equals(bean.ClientID))
                return bean.Company;
            else
                continue;
        }

        return clientId;
    }

    //状态转换名称
    public string StatusToName(string status)
    {
        if (string.IsNullOrEmpty(status))
            return "";
        else if (status.Equals("0"))
            return "待审核";
        else if (status.Equals("1"))
            return "审核中";
        else if (status.Equals("2"))
            return "审核通过";
        else if (status.Equals("3"))
            return "审核不通过";
        else if (status.Equals("4"))
            return "取消";
        else
            return status;
    }
}