1.系统账户数据库优化： 修改“账户类型”的数据类型为VARCHAR2(1024)，多个角色时以半角“,”分隔。 加密盐。 密码加密优化；账户...

yzh

2022-06-15 f63d8ead25bdb3c32dacca817a059bd30390e9bc

 web/web/GwClient.aspx.cs

@@ -5,12 +5,283 @@
using System.Web;
using System.Web.Profile;
using System.Web.SessionState;
using Dao;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Linq;

public partial class _GwClient : PageBase<SysUser>, IRequiresSessionState
{ 
{

    protected List<SysUser> SysUserList;
    protected List<GwProduct> GwProductList;    

    string addressClasses = ConfigurationManager.AppSettings["addressClasses"];

    protected void Page_Load(object sender, EventArgs e)
    {
        //权限校验
        this.CheckRight("301", FailedOperation.ErrorMsgOnly);

        //获取启用的产品分类
        using (UserDao userDao = new UserDao())
        {

            int recordCount = 0;
            int int1 = 999999999;
            int int2 = 1;
            this.SysUserList = userDao.LoadInfoList(out recordCount, int1, int2);

        }

        //获取启用的产品
        using (GwProductDao gwProductDao = new GwProductDao())
        {
            GwProduct bean = new GwProduct();
            bean.Classes = 1;
            bean.IsDefault = -1;
            bean.IsEnable = -1;
            this.GwProductList = gwProductDao.getAllList(bean);
        }
    }
    public int IsEnable
    {
        get
        {
            return this.AppContext.GetInt("IsEnable");
        }
    }


    //归属业务员
    public string salesmanOptions(int userId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.SysUserList.Count == 0)
            return "<option value=''>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)"", (object)"无");
        foreach (SysUser bean in this.SysUserList)
        {
            //停用的用户不再显示
            if (bean.Status == 0)
            {
                continue;
            }
            //过滤用户类型 1-管理员;2-业务员--全员;3-客户经理;4-客服人员;5-财务人员
            if (!checkStrForArrayStr(1, bean.UserType) && !checkStrForArrayStr(2, bean.UserType) )
            {
                continue;
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }

    //归属客户经理
    public string customerManagerOptions(int userId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.SysUserList.Count == 0)
            return "<option value=''>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)"", (object)"无");
        foreach (SysUser bean in this.SysUserList)
        {
            //停用的用户不再显示
            if (bean.Status == 0)
            {
                continue;
            }
            //过滤用户类型 1-管理员;2-业务员--全员;3-客户经理;4-客服人员;5-财务人员
            if (!checkStrForArrayStr(1, bean.UserType) && !checkStrForArrayStr(3, bean.UserType))
            {
                continue;
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }

    //归属客服人员
    public string supportStaffOptions(int userId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.SysUserList.Count == 0)
            return "<option value=''>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)"", (object)"无");
        foreach (SysUser bean in this.SysUserList)
        {
            //停用的用户不再显示
            if (bean.Status == 0)
            {
                continue;
            }
            //过滤用户类型 1-管理员;2-业务员--全员;3-客户经理;4-客服人员;5-财务人员
            if (!checkStrForArrayStr(1, bean.UserType) && !checkStrForArrayStr(4, bean.UserType))
            {
                continue;
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }

    //归属财务人员
    public string financialStaffOptions(int userId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.SysUserList.Count == 0)
            return "<option value=''>无</option>";
        stringBuilder.AppendFormat("<option value=\"{0}\" >{1}</option>", (object)"", (object)"无");
        foreach (SysUser bean in this.SysUserList)
        {
            //停用的用户不再显示
            if (bean.Status == 0)
            {
                continue;
            }
            //过滤用户类型 1-管理员;2-业务员--全员;3-客户经理;4-客服人员;5-财务人员
            if (!checkStrForArrayStr(1, bean.UserType) && !checkStrForArrayStr(5, bean.UserType))
            {
                continue;
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }


    //获取产品信息
    public string GetProductOptions(string productId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.GwProductList.Count == 0)
            return "<option value=''>无</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();
    }


    //获取个性产品信息
    public string GetPersonalityProductOptions(string productId)
    {
        StringBuilder stringBuilder = new StringBuilder();
        if (this.GwProductList.Count == 0)
            return "<option value=''>无</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 (bean.IsDefault == 1)
            {
                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();
    }

    //所有个性产品
    protected string ClientProductAll()
    {
        using (GwProductDao gwProductDao = new GwProductDao())
        {
            GwProduct gwProduct = new GwProduct();
            gwProduct.Classes = 1;  //0-产品分类；1-产品
            gwProduct.IsDefault = 0;    //默认值0。0-个性化；1-系统默认。
            gwProduct.IsEnable = 1;    //0-停用；1-启用；默认1
            List<GwProduct> list = gwProductDao.getAllList(gwProduct);

            StringBuilder stringBuilder = new StringBuilder();
            stringBuilder.Append("<table cellpadding='5'>");
            if(list.Count>0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    GwProduct bean = (GwProduct)list[i];

                    //行开始符
                    if (i%5 == 0)
                    {
                        stringBuilder.Append("<tr>");
                    }

                    //行单元格
                    stringBuilder.AppendFormat("<td><input  type=\"checkbox\" id=\"_ProductId\"  name=\"_ProductId\" value=\"{0}\" /><span  style='padding:5px;'>{1} </span>  \r\n         </td>", (object)bean.Id, (object)bean.Name);

                    //行结束符
                    if (i % 5 == 4 || i == (list.Count - 1))
                    {
                        stringBuilder.Append("</tr>");
                    }

                }
            }
            stringBuilder.Append("</table>");

            return stringBuilder.ToString();
        }
    }

    //检查数组格式字符串中是否包含某元素
    public static bool checkStrForArrayStr(object str, string arrayStr)
    {
        return stringToArray(arrayStr).Contains(str);
    }

    //字符串转数组
    public static object[] stringToArray(string str)
    {
        object[] array = str.Split(',');
        return array;
    }

}