产品分配账户

yzh

2021-10-11 6c4ea53f92500f49959013c36b5c67fed25cd791

 web/web/GwClient.ashx

@@ -3,12 +3,14 @@
using System.Web;
using Dao;
using Common;

using System.Collections.Generic;
using System.Configuration;
using System.Text;
using System.Text.RegularExpressions;
 
using System.IO;
using Newtonsoft.Json;




public class GwClientHandler : PageHandler<Model.SysUser>
@@ -21,9 +23,15 @@
        {
            case "clientSpList":
                return this.GetGwspList(context);
                

            case "loadGwClientPageList":
                return LoadGwClientPageList(context);
            //待推送账户查询列表
            case "loadGwClientAllPageList":
                return LoadGwClientAllPageList(context);
            //确定推送
            case "saveClientProduct":
                return SaveClientProduct(context);
            case "save":
                return Save(context);

@@ -53,9 +61,11 @@
        }
    }
    private Dao.GwClientDao _Dao = new Dao.GwClientDao();
    private Dao.GwClientProductDao gwClientProductDao = new Dao.GwClientProductDao();
    private Dao.SysXhDao sysXhDao = new Dao.SysXhDao();
    private GwSpDao _GwSpDao = new GwSpDao();

    

    /// <summary>
    /// 加载代理商账号列表
    /// </summary>
@@ -64,6 +74,7 @@
    private JsonPageResult LoadGwClientPageList(PageContext<Model.SysUser> context)
    {
        string ClientID = context.GetString("ClientID");
        string Company = context.GetString("Company");
        string ClientName = context.GetString("ClientName");
        string Telephone = context.GetString("Telephone");
        int pageIndex = context.GetInt("pageIndex", 1);
@@ -76,13 +87,18 @@
        string str = "";
        using (GwClientDao dao = new GwClientDao())
        {
            var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, ClientID, ClientName, Telephone, Agent);
                
            var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, ClientID, Company, ClientName, Telephone, Agent);

            if (list != null && list.Count > 0)
            {
                foreach (Model.GwClient item in list)
                {
                    str += @"<tr ><td>" + item.ClientID + "</td><td>" + item.ClientName + "</td><td>" + item.Telephone + "</td><td>" +item.TotalAmount / 1000 + "元/" + item.Balance / 1000 + "元</td><td>" + item.Agent + "</td><td>" + item.Remark + "</td>";
                    string Certification_StatusResult = "未认证";
                    if (item.Certification_Status == 1)
                    { 
                            Certification_StatusResult = "已认证";
                     }
                    str += @"<tr ><td>" + item.ClientID + "</td><td>" + item.Company + "</td><td>" + item.ClientName + "</td><td>" + item.Telephone + "</td><td>" + item.Top_up_Amount_Total + "元</td><td>" + item.Agent + "</td><td>" + Certification_StatusResult + "</td>";

                    str += @"<td>";
                    string loginStr = "http://" + serverIp + ":" + clientPort + "/Attachedlogin.aspx?action=Attachedlogin&account=" + item.Account + "&password=" + item.Password;
@@ -112,13 +128,81 @@
            {
                str += @"<tr><td colspan=""8"">暂无信息</td></tr>";
            }
            

        }
        return new JsonPageResult(true, new { Table = str.ToString(), TotalCount = recordCount });
    }

    //add 2017-10-21
        
    /// <summary>
    /// 加载待推送产品的代理商账号列表
    /// </summary>
    /// <param name="context"></param>
    /// <returns></returns>
    private JsonPageResult LoadGwClientAllPageList(PageContext<Model.SysUser> context)
    {
        int pageIndex = context.GetInt("pageIndex", 1);
        int recordCount = 0;
        int pageSize = context.GetInt("pageSize", 20);
        string serverIp = ConfigurationManager.AppSettings["serverIp"];
        string clientPort = ConfigurationManager.AppSettings["clientPort"];
        string str = "";
        using (GwClientDao dao = new GwClientDao())
        {
            var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, null, null, null, null, null);

            if (list != null && list.Count > 0)
            {
                foreach (Model.GwClient item in list)
                {
                    string Certification_StatusResult = "未认证";
                    if (item.Certification_Status == 1)
                    { 
                            Certification_StatusResult = "已认证";
                     }
                    str += "<tr><td  rowspan=\"1\" ><input type=\"checkbox\"name=\"checkbox\" value=\"" + item.ClientID + "\"/></td>" ;
                    str += @"<td>" + item.ClientID + "</td><td>" + item.Company + "</td><td>" + item.ClientName + "</td><td>" + item.Telephone + "</td><td>" + item.Top_up_Amount_Total + "元</td><td>" + item.Agent + "</td><td>" + Certification_StatusResult + "</td>";

                    str += @"</tr>";
                }
            }
            else
            {
                str += @"<tr><td colspan=""8"">暂无信息</td></tr>";
            }

        }
        return new JsonPageResult(true, new { Table = str.ToString(), TotalCount = recordCount });
    }

    //确定推送
    private JsonPageResult SaveClientProduct(PageContext<Model.SysUser> context)
    {
        string product_id = context.GetString("product_id");
        if (string.IsNullOrEmpty(product_id))
            throw new ArgumentException("请选择要分配的产品！");

        foreach (string clientId in JsonConvert.DeserializeObject<string[]>(context.GetString("idArray"))) { 
                if(gwClientProductDao.IsClientProductExists(clientId, product_id))
            {
                    continue;
            }else {
                Model.GwClientProduct gwClientProduct = new Model.GwClientProduct();
                string client_product_id = sysXhDao.getXh("GW_CLIENT_PRODUCT");
                gwClientProduct.client_product_id = client_product_id;
                gwClientProduct.client_id = clientId;
                gwClientProduct.product_id = product_id;
                gwClientProduct.activate_status = 0;

                //保存产品分配给账户
                this.gwClientProductDao.Add(gwClientProduct);
             }
        }
        return new JsonPageResult(true, (object)"确定分配账户产品成功！");
    }


    //add 2017-10-21
    private JsonPageResult GetGwspList(PageContext<Model.SysUser> context)
    {
        string clientID = context.GetString("clientID");
@@ -145,10 +229,10 @@
            get = gwClient
        });
    }
    

    //end
    
    


    private JsonPageResult UpdateWhite(PageContext<Model.SysUser> context)
    {
        string clientID = context.GetString("clientID");
@@ -210,7 +294,7 @@
        return new JsonPageResult(true, "删除客户资料成功！");
    }

 

    /// <summary>
    /// 保存客户资料
    /// </summary>
@@ -261,16 +345,17 @@
        return new JsonPageResult(true, "修改客户资料成功！");
    }

    //创建新客户
    ///创建新客户
    private JsonPageResult Save(PageContext<Model.SysUser> context)
    {
        string clientID = context.GetString("clientID");
        string password = context.GetString("password");
        string clientName = context.GetString("clientName");
        //string clientName = context.GetString("clientName");
        string address = context.GetString("address");
        string telephone = context.GetString("telephone");
        string remark = context.GetString("remark");
        string agent = context.GetString("agent");
        string company = context.GetString("company");
        string permissionData = Newtonsoft.Json.JsonConvert.SerializeObject(context.GetString("permissionData").Split(','));

        if (string.IsNullOrEmpty(clientID))
@@ -283,33 +368,74 @@
            throw new ArgumentException("客户密码不能为空，且必须为4-10位英文或数字字符组合！");
        }

        if (string.IsNullOrEmpty(clientName))
        {
            throw new ArgumentException("客户名称不能为空！");
        }
        //if (string.IsNullOrEmpty(clientName))
        //{
        //    throw new ArgumentException("客户名称不能为空！");
        //}

        if (_Dao.IsIDExists(clientID))
        {
            throw new ArgumentException("客户账号已经存在！");
        }

        HttpFileCollection _file = HttpContext.Current.Request.Files;
        if (_file.Count > 0)
        {
            long size = _file[0].ContentLength; //文件大小
            string type = _file[0].ContentType; //文件类型
            string name = _file[0].FileName; //文件名
            string _tp = Path.GetExtension(name);//文件扩展名
            if (_tp.ToLower() == ".jpg" || _tp.ToLower() == ".jpeg" || _tp.ToLower() == ".gif" || _tp.ToLower() == ".png")
            {
                Stream stream = _file[0].InputStream;//获取文件流
                string savaName = clientID + "-" + DateTime.Now.ToString("yyyyMMddHHssmm") + _tp; //保存文件。文件名
                string filepath = "\\UploadFile\\" + savaName;
                string path = AppDomain.CurrentDomain.BaseDirectory + filepath;//图片路径
                _file[0].SaveAs(path);

                try
                {
                    //创建审核通过的记录
                    Model.GwClientCertification gwClientCertification = new Model.GwClientCertification();
                    gwClientCertification.Client_ID = clientID;
                    gwClientCertification.Certificate_Path = path;
                    gwClientCertification.Client_Classes = 0;//类型：0-企业、1-个人
                    gwClientCertification.Audit_Status = 1;//审核状态，0-待审核，1-通过，2-不通过
                    gwClientCertification.Certification_Time = DateTime.Now;//认证审核时间
                    gwClientCertification.Operator = context.OperatorID;//操作审核人
                    gwClientCertification.Upload_Time = DateTime.Now;//上传时间
                    gwClientCertification.Remark = "管理后台操作创建";

                    //保存审核记录
                    GwClientCertificationDao certificationDao = new GwClientCertificationDao();
                    certificationDao.Insert(gwClientCertification);
                }
                catch (Exception ex)
                {
                    return new JsonPageResult(false, "上传图片处理异常：" + ex.Message);
                }
            }
        }


        var client = new Model.GwClient();
        client.ClientID = clientID;
        client.Password = password;
        
        client.ClientName = clientName;

        //client.ClientName = clientName;
        client.Address = address;
        client.Remark = remark;
        client.Telephone = telephone;
        client.Agent = agent;
        client.PermissionData = permissionData;
        client.ParentId = context.OperatorID;
        
        _Dao.Add(client);
        client.Certification_Status = 1;
        client.Company = company;
        _Dao.Add(client);//插入数据库。创建账户

        return new JsonPageResult(true, "创建客户成功！");
        return new JsonPageResult(true, "创建账户成功！");
    }
} 
}