Esempio n. 1
0
    public void DataBinds()
    {
        int       pageCount    = 0;
        int       Counts       = 0;
        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(1, 1, "SYS_CompUser.createdate", false, " users.Tel,Identitys,Email,Address,SYS_CompUser.id,UserName,SYS_CompUser.compid,trueName,utype Type,Phone,SYS_CompUser.IsEnabled,SYS_CompUser.createdate,SYS_CompUser.CompID ,OpenID,Sex ", JoinTableStr, "  and SYS_CompUser.id=" + KeyID + "", out pageCount, out Counts);

        if (LUser.Rows.Count > 0)
        {
            lblCompName.InnerText  = Common.GetCompValue(LUser.Rows[0]["CompID"].ToString().ToInt(0), "CompName") == null ? "" : Common.GetCompValue(LUser.Rows[0]["CompID"].ToString().ToInt(0), "CompName").ToString();
            lblUserName.InnerText  = LUser.Rows[0]["UserName"].ToString();
            lblOpenID.InnerText    = LUser.Rows[0]["OpenID"].ToString();
            lblSex.InnerText       = LUser.Rows[0]["Sex"].ToString();
            lblPhone.InnerText     = LUser.Rows[0]["Phone"].ToString();
            lblTel.InnerText       = LUser.Rows[0]["Tel"].ToString();
            lblIdentitys.InnerText = LUser.Rows[0]["Identitys"].ToString();
            lblTrueName.InnerText  = LUser.Rows[0]["TrueName"].ToString();
            lblIsEnabled.InnerHtml = LUser.Rows[0]["IsEnabled"].ToString().ToInt(0) == 1 ? "启用" : "<i style='color:red;'>禁用</i>";
            lblEmail.InnerText     = LUser.Rows[0]["Email"].ToString();
            lblAddress.InnerText   = LUser.Rows[0]["Address"].ToString();
        }
        else
        {
            Response.Write("该用户不存在。");
            Response.End();
        }
    }
Esempio n. 2
0
    public void DataBinds()
    {
        int pageCount = 0;
        int Counts    = 0;

        if (this.txtPageSize.Value.ToString() != "")
        {
            if (this.txtPageSize.Value.Trim().Length >= 5)
            {
                Pager.PageSize         = 100;
                this.txtPageSize.Value = "100";
            }
            else
            {
                Pager.PageSize = this.txtPageSize.Value.Trim().ToInt(0);
            }
        }

        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 inner join BD_Company on SYS_CompUser.CompID=BD_Company.ID and BD_Company.dr=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(Pager.PageSize, Pager.CurrentPageIndex, "SYS_CompUser.createdate", false, "SYS_CompUser.CompID, SYS_CompUser.id,UserName,SYS_CompUser.Disid,trueName,utype Type,Users.Phone,SYS_CompUser.IsEnabled,SYS_CompUser.createdate ", JoinTableStr, SearchWhere(), out pageCount, out Counts);

        this.Rpt_Disuser.DataSource = LUser;
        this.Rpt_Disuser.DataBind();
        Pager.RecordCount = Counts;
        page = Pager.CurrentPageIndex.ToString();
    }
Esempio n. 3
0
 public string ExistsUserPhone(string Phone)
 {
     if (KeyID != 0)
     {
         List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("Userid", "   id=" + KeyID + " and DisID=" + DisID + " and ctype=2 ", "");
         string id = ListCompUser.Count > 0 ? ListCompUser[0].UserID.ToString() : "0";
         if (Common.GetUserExists("Phone", Phone, id))
         {
             return("{ \"result\":true}");
         }
         else
         {
             return("{ \"result\":false}");
         }
     }
     else
     {
         if (Common.GetUserExists("Phone", Phone))
         {
             return("{ \"result\":true}");
         }
         else
         {
             return("{ \"result\":false}");
         }
     }
 }
Esempio n. 4
0
    public void DataBinds()
    {
        int       pageCount    = 0;
        int       Counts       = 0;
        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(1, 1, "SYS_CompUser.createdate", false, " users.Tel,Identitys,Email,Address,SYS_CompUser.id,UserName,SYS_CompUser.compid,trueName,utype Type,Phone,SYS_CompUser.IsEnabled,SYS_CompUser.createdate,SYS_CompUser.DisID ,OpenID,Sex ", JoinTableStr, "  and SYS_CompUser.id=" + KeyID + "", out pageCount, out Counts);

        if (LUser.Rows.Count > 0)
        {
            lblDisName.InnerText   = Common.GetDisValue(LUser.Rows[0]["DisID"].ToString().ToInt(0), "disname").ToString();
            lblUname.InnerText     = LUser.Rows[0]["UserName"].ToString();
            lblOpenID.InnerText    = LUser.Rows[0]["OpenID"].ToString();
            lblSex.InnerText       = LUser.Rows[0]["Sex"].ToString();
            lblPhone.InnerText     = LUser.Rows[0]["Phone"].ToString();
            lblTel.InnerText       = LUser.Rows[0]["Tel"].ToString();
            lblIdentitys.InnerText = LUser.Rows[0]["Identitys"].ToString();
            lblTrueName.InnerText  = LUser.Rows[0]["TrueName"].ToString();
            lblIsEnabled.InnerHtml = LUser.Rows[0]["IsEnabled"].ToString().ToInt(0) == 1 ? "启用" : "<i style='color:red;'>禁用</i>";
            lblEmail.InnerText     = LUser.Rows[0]["Email"].ToString();
            //lblAddress.InnerText = user.Address;
        }
        else
        {
            JScript.AlertMethod(this, "该用户不存在!", JScript.IconOption.错误, " function (){ location.href='DisUserList.aspx' }");
            return;
        }
    }
Esempio n. 5
0
 public void DataBinds()
 {
     if (KeyID > 0)
     {
         int       pageCount    = 0;
         int       Counts       = 0;
         string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
         DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(1, 1, "SYS_CompUser.createdate", false, "UserPwd, users.Tel,Identitys,Email,Address,SYS_CompUser.id,UserName,SYS_CompUser.compid,trueName,utype Type,Phone,SYS_CompUser.IsEnabled,SYS_CompUser.createdate,SYS_CompUser.CompID ,OpenID,Sex ", JoinTableStr, "  and SYS_CompUser.id=" + KeyID + "", out pageCount, out Counts);
         if (LUser.Rows.Count > 0)
         {
             txtUname.Value    = LUser.Rows[0]["UserName"].ToString();
             txtTrueName.Value = LUser.Rows[0]["UserName"].ToString();
             txtOpenID.Value   = LUser.Rows[0]["OpenID"].ToString();
             txtUpwd.Attributes.Add("value", LUser.Rows[0]["UserPwd"].ToString());
             if (LUser.Rows[0]["IsEnabled"].ToString().ToInt(0) == 0)
             {
                 rdEnabledYes.Checked = false;
                 rdEnabledNo.Checked  = true;
             }
             if (LUser.Rows[0]["Sex"].ToString() == "女")
             {
                 rdMan.Checked   = false;
                 rdWomen.Checked = true;
             }
             txtMobil.Value = LUser.Rows[0]["Phone"].ToString();
             txtPhone.Value = LUser.Rows[0]["Tel"].ToString();
             txtPId.Value   = LUser.Rows[0]["Identitys"].ToString();
             txtEmail.Value = LUser.Rows[0]["Email"].ToString();
             LUser.Rows[0]["Address"].ToString();
         }
     }
 }
Esempio n. 6
0
 protected void btnEdit_Click(object sender, EventArgs e)
 {
     if (KeyID > 0)
     {
         List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and id=" + KeyID + "", "");
         if (ListCompUser.Count > 0)
         {
             SqlTransaction     Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
             Hi.Model.SYS_Users user = new Hi.BLL.SYS_Users().GetModel(ListCompUser[0].UserID);
             user.TrueName = Common.NoHTML(txtTrueName.Value.Trim());
             user.OpenID   = Common.NoHTML(txtOpenID.Value.Trim());
             if (rdMan.Checked)
             {
                 user.Sex = "男";
             }
             else
             {
                 user.Sex = "女";
             }
             user.Tel = Common.NoHTML(txtPhone.Value.Trim());
             if (txtUpwd.Text.Trim() != user.UserPwd)
             {
                 user.UserPwd = Util.md5(txtUpwd.Text.Trim());
             }
             user.Identitys            = Common.NoHTML(txtPId.Value.Trim());
             ListCompUser[0].IsEnabled = rdEnabledYes.Checked ? 1 : 0;
             user.Email   = Common.NoHTML(txtEmail.Value.Trim());
             user.Address = Common.NoHTML(txtAddress.Value.Trim());
             new Hi.BLL.SYS_Users().Update(user, Tran);
             new Hi.BLL.SYS_CompUser().Update(ListCompUser[0], Tran);
             Tran.Commit();
             ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>window.location.href='CompUserInfo.aspx?KeyID=" + KeyID + "';</script>");
         }
     }
 }
Esempio n. 7
0
    /// <summary>
    /// 禁用
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btn_Del(object sender, EventArgs e)
    {
        Hi.Model.SYS_CompUser        User         = new Hi.BLL.SYS_CompUser().GetModel(KeyID);
        List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("top 1 *", "   UserID=" + KeyID + " and DisID=" + DisID + " and ctype=2 ", "");

        if (ListCompUser.Count > 0)
        {
            if (ListCompUser[0].UType == 5)
            {
                JScript.AlertMsgOne(this, "该用户为管理员,不可禁用!", JScript.IconOption.错误, 2500);
                return;
            }
            else
            {
                ListCompUser[0].IsEnabled  = 0;
                ListCompUser[0].ts         = DateTime.Now;
                ListCompUser[0].modifyuser = UserID;
                if (new Hi.BLL.SYS_CompUser().Update(ListCompUser[0]))
                {
                    this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "msg", "<script>window.parent.save();</script>");
                }
            }
        }
        else
        {
            JScript.AlertMsgOne(this, "用户不存在!", JScript.IconOption.错误, 2500);
            return;
        }
        DataBinds();
    }
Esempio n. 8
0
    protected void btn_Use(object sender, EventArgs e)
    {
        List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("top 1 *", "   UserID=" + KeyID + " and DisID=" + DisID + " and ctype=2 ", "");

        if (ListCompUser.Count > 0)
        {
            List <Hi.Model.SYS_Role> ListRole = new Hi.BLL.SYS_Role().GetList("RoleName,IsEnabled", " dr=0 and id=" + ListCompUser[0].RoleID + "", "");
            if (ListRole.Count > 0)
            {
                if (ListRole[0].IsEnabled == 0)
                {
                    JScript.AlertMsgOne(this, "请先启用该人员所在岗位(" + ListRole[0].RoleName + ")!", JScript.IconOption.错误, 2500);
                    return;
                }
            }
            ListCompUser[0].IsEnabled  = 1;
            ListCompUser[0].ts         = DateTime.Now;
            ListCompUser[0].modifyuser = UserID;
            if (new Hi.BLL.SYS_CompUser().Update(ListCompUser[0]))
            {
                this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "msg", "<script>window.parent.save();</script>");
            }
        }
        else
        {
            JScript.AlertMsgOne(this, "用户不存在!", JScript.IconOption.错误, 2500);
            return;
        }
        DataBinds();
    }
Esempio n. 9
0
    protected void btn_Use(object sender, EventArgs e)
    {
        Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID);
        if (Dis != null)
        {
            List <Hi.Model.SYS_CompUser> luser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and DisID=" + KeyID + " and Utype in (1,5) and Ctype=2 and CompID=" + this.CompID, "");

            foreach (Hi.Model.SYS_CompUser model in luser)
            {
                model.IsEnabled  = 1;
                model.ts         = DateTime.Now;
                model.modifyuser = Common.UserID();
                new Hi.BLL.SYS_CompUser().Update(model);
            }

            if (Request["nextstep"] + "" == "1")
            {
                Response.Redirect("DisList.aspx?nextstep=1");
            }
            else
            {
                Response.Redirect("DisInfo.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey) + "&type=2");
            }
        }
    }
Esempio n. 10
0
    public void DataBindComp()
    {
        if (!string.IsNullOrWhiteSpace(ComList[0].CustomCompinfo))
        {
            DivContent.InnerHtml = ComList[0].CustomCompinfo;
        }
        else
        {
            DivContent.InnerHtml = ComList[0].CompInfo;
        }
        LoginModel logUser = HttpContext.Current.Session["UserModel"] as LoginModel;

        if (logUser != null)
        {
            lblAddress.InnerHtml = "地 址:" + ComList[0].Address;
            if (!string.IsNullOrWhiteSpace(ComList[0].Principal))
            {
                lblPrincipal.InnerHtml = "联系人:" + ComList[0].Principal;
            }
            if (!string.IsNullOrWhiteSpace(ComList[0].Phone))
            {
                lblPhone.InnerHtml = "电 话:" + ComList[0].Phone;
            }
            lbllogin.Visible = false;

            List <Hi.Model.SYS_CompUser> User2 = new Hi.BLL.SYS_CompUser().GetList("", "isnull(dr,0)=0 and IsEnabled=1 and utype=4  and CompID=" + ViewState["Compid"], "");
            if (User2.Count > 0)
            {
                Hi.Model.SYS_Users User = new Hi.BLL.SYS_Users().GetModel(User2[0].UserID);
                if (User != null)
                {
                    if (!string.IsNullOrWhiteSpace(ComList[0].Principal))
                    {
                        lblPrincipal.InnerHtml = "联系人:" + ComList[0].Principal;
                    }
                    else
                    {
                        lblPrincipal.InnerHtml = "联系人:" + User.TrueName;
                    }
                    if (!string.IsNullOrWhiteSpace(ComList[0].Phone))
                    {
                        lblPhone.InnerHtml = "电 话:" + ComList[0].Phone;
                    }
                    else
                    {
                        lblPhone.InnerHtml = "电 话:" + User.Phone;
                    }
                }
            }
        }
        else
        {
            lblPrincipal.InnerHtml = "<i>联系人:</i>" + "***";
            lblPhone.InnerHtml     = "<i>电 话:</i>" + "***";
            lblAddress.InnerHtml   = "<i>地 址:</i>" + "***";
            lbllogin.InnerHtml     = "<a href=\"/login.html\"><i  style=\" color:Red;\">请先登录>></i></a>";
        }
    }
Esempio n. 11
0
    protected void btn_Del(object sender, EventArgs e)
    {
        Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID);
        if (Dis != null)
        {
            //if (Dis.AuditState == 2 && Dis.IsEnabled == 1)
            //{
            //    JScript.AlertMsgOne(this, "已审核未被禁用的代理商不允许删除!", JScript.IconOption.错误);
            //    return;
            //}
            //Dis.dr = 1;
            //Dis.ts = DateTime.Now;
            //Dis.modifyuser = Common.UserID();

            List <int> ListUserid              = new List <int>();
            List <int> ListDelUserid           = new List <int>();
            List <Hi.Model.SYS_CompUser> luser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and DisID=" + KeyID + " and Utype in (1,5) and Ctype=2 and CompID=" + this.CompID, "");

            foreach (Hi.Model.SYS_CompUser model in luser)
            {
                if (model.IsAudit == 2 && model.IsEnabled == 1)
                {
                    JScript.AlertMsgOne(this, "已审核未被禁用的代理商不允许删除!", JScript.IconOption.错误);
                    return;
                }

                if (!ListUserid.Contains(model.UserID))
                {
                    List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("id", " dr=0 and Userid=" + model.UserID + " and CompID=" + this.CompID, "");
                    if (ListCompUser.Count == 1)
                    {
                        ListDelUserid.Add(model.UserID);
                    }
                    ListUserid.Add(model.UserID);
                }
                model.dr         = 1;
                model.ts         = DateTime.Now;
                model.modifyuser = Common.UserID();
                new Hi.BLL.SYS_CompUser().Update(model);
            }
            if (ListDelUserid.Count > 0)
            {
                List <Hi.Model.SYS_Users> ListUsers = new Hi.BLL.SYS_Users().GetList("", " dr=0 and id in(" + string.Join(",", ListDelUserid) + ")", "");
                foreach (Hi.Model.SYS_Users model in ListUsers)
                {
                    model.dr         = 1;
                    model.ts         = DateTime.Now;
                    model.modifyuser = Common.UserID();
                    new Hi.BLL.SYS_Users().Update(model);
                }
            }
            //string Phone = Common.GetDis(Dis.ID, "Phone");
            //string msg = "您所注册的代理商:" + Dis.DisName + "已注销![ " + Common.GetCompValue(CompID, "CompName") + " ]";
            //Common.GetPhone(Phone, msg);
            JScript.AlertMethod(this, "删除成功!", JScript.IconOption.错误, "function(){ window.location.href='DisList.aspx'; }");
        }
    }
Esempio n. 12
0
    public void DataBinds()
    {
        if (KeyID != 0)
        {
            //Hi.Model.SYS_Users User = new Hi.BLL.SYS_Users().GetModel(KeyID);
            int    pageCount    = 0;
            int    Counts       = 0;
            string JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";

            DataTable dt = new Hi.BLL.SYS_CompUser().GetList(1, 1, "SYS_CompUser.ID", true, "SYS_CompUser.DisID,SYS_CompUser.id,Address,SYS_CompUser.RoleId,UserName,SYS_CompUser.createdate,TrueName,Phone,Identitys,Email,SYS_CompUser.IsEnabled,SYS_CompUser.CompID", JoinTableStr, "and SYS_CompUser.UserID= " + KeyID, out pageCount, out Counts);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["DisID"].ToString().ToInt(0) != this.DisID)
                {
                    JScript.AlertMsgOne(this, "该用户不允许查看!", JScript.IconOption.错误, 2500);
                    return;
                }
                if (dt.Rows[0]["IsEnabled"].ToString().ToInt(0) == 1)
                {
                    UseIcon.Visible   = false;
                    NUseIcon.Visible  = true;
                    DleteIcon.Visible = false;
                }
                else
                {
                    NUseIcon.Visible  = false;
                    UseIcon.Visible   = true;
                    DleteIcon.Visible = true;
                }
                //Hi.Model.SYS_Role ll = new Hi.BLL.SYS_Role().GetModel(dt.Rows[0]["RoleID"].ToString().ToInt(0));
                lblTrueName.InnerText = dt.Rows[0]["TrueName"].ToString();
                //lblSex.InnerText = User.Sex;
                lblPhone.InnerText = dt.Rows[0]["Phone"].ToString();
                //lblTel.InnerText = User.Tel;
                lblIdentitys.InnerText = dt.Rows[0]["Identitys"].ToString();
                lblIsEnabled.InnerText = dt.Rows[0]["IsEnabled"].ToString().ToInt(0) == 1 ? "启用" : "禁用";
                lblEmail.InnerText     = dt.Rows[0]["Email"].ToString();
                //if (ll != null)
                //{
                //    lblRoleId.InnerText = ll.RoleName;
                //}
                //lblUserLoginName.InnerText = User.UserLoginName.ToString();
                lblUserName.InnerText = dt.Rows[0]["UserName"].ToString();
                lblAddress.InnerText  = dt.Rows[0]["Address"].ToString();;
            }
            else
            {
                JScript.AlertMsgOne(this, "用户不存在!", JScript.IconOption.错误, 2500);
                return;
            }
        }
        else
        {
            JScript.AlertMsgOne(this, "数据错误!", JScript.IconOption.错误, 2500);
            return;
        }
    }
Esempio n. 13
0
    /// <summary>
    /// 获取登录用户厂商ID
    /// </summary>
    /// <param name="UserID"></param>
    /// <returns></returns>
    public static int GetUserCompID(string UserID)
    {
        List <Hi.Model.SYS_CompUser> culist = new Hi.BLL.SYS_CompUser().GetList("", " UserID=" + UserID + " and Ctype=1 and UType=4", "");

        if (culist != null && culist.Count > 0)
        {
            return(culist[0].CompID);
        }
        return(0);
    }
Esempio n. 14
0
    protected void btn_Save1(object sender, EventArgs e)
    {
        Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
        if (Dis != null)
        {
            if (Common.DisExistsAttribute("DisName", txtDisName.Value.Trim(), this.CompID.ToString(), this.DisID.ToString()))
            {
                JScript.AlertMsgOne(this, "代理商已存在!", JScript.IconOption.错误, 2500);
                return;
            }
            Dis.Province     = Common.NoHTML(hidProvince.Value.Trim());
            Dis.City         = Common.NoHTML(hidCity.Value.Trim());
            Dis.Area         = Common.NoHTML(hidArea.Value.Trim());
            Dis.DisName      = Common.NoHTML(txtDisName.Value.Trim());
            Dis.Licence      = Common.NoHTML(txtLicence.Value.Trim());
            Dis.Tel          = Common.NoHTML(txtTel.Value.Trim());
            Dis.Principal    = Common.NoHTML(txtname.Value);
            Dis.Phone        = Common.NoHTML(txtnamephone.Value);
            Dis.Zip          = Common.NoHTML(txtZip.Value.Trim());
            Dis.Fax          = Common.NoHTML(txtFax.Value.Trim());
            Dis.Address      = Common.NoHTML(txtAddress.Value.Trim());
            Dis.Leading      = Common.NoHTML(txtLeading.Value.Trim());
            Dis.LeadingPhone = Common.NoHTML(txtLeadingPhone.Value.Trim());
            if (!string.IsNullOrEmpty(HidFfileName.Value))
            {
                if (Dis.pic == "")
                {
                    Dis.pic = Common.NoHTML(HidFfileName.Value);
                }
                else
                {
                    Dis.pic += "," + Common.NoHTML(HidFfileName.Value);
                }
            }
            Dis.ts         = DateTime.Now;
            Dis.modifyuser = this.UserID;
            if (new Hi.BLL.BD_Distributor().Update(Dis))
            {
                List <Hi.Model.SYS_CompUser> user2 = new Hi.BLL.SYS_CompUser().GetList("UserID", "  isnull(dr,0)=0 and  disId='" + this.DisID + "' and utype=5", "");
                if (user2.Count > 0)
                {
                    Hi.Model.SYS_Users u = new Hi.BLL.SYS_Users().GetModel(user2[0].UserID);

                    if (u != null)
                    {
                        u.ts         = DateTime.Now;
                        u.modifyuser = this.UserID;
                        u.TrueName   = Common.NoHTML(txtUserTrueName.Value);
                        new Hi.BLL.SYS_Users().Update(u);
                    }
                }
                Response.Redirect("PhoneEdit.aspx?type=hf");
            }
        }
    }
Esempio n. 15
0
    //public void DataBinds()
    //{
    //    int pageCount = 0;
    //    int Counts = 0;
    //    //每页显示的数据设置
    //    if (this.txtPageSize.Value.ToString() != "")
    //    {
    //        if (this.txtPageSize.Value.Trim().Length >= 5)
    //        {
    //            Pager.PageSize = 100;
    //            this.txtPageSize.Value = "100";
    //        }
    //        else
    //        {
    //            Pager.PageSize = this.txtPageSize.Value.Trim().ToInt(0);
    //        }
    //    }
    //    string JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
    //    DataTable LUser = new Hi.BLL.SYS_CompUser().GetList(Pager.PageSize, Pager.CurrentPageIndex, "SYS_CompUser.createdate", false, " SYS_CompUser.id,UserID,UserName,SYS_CompUser.createdate,TrueName,Phone,Identitys,Email,SYS_CompUser.IsEnabled ", JoinTableStr, SearchWhere(), out pageCount, out Counts);
    //    this.Rpt_Company.DataSource = LUser;
    //    this.Rpt_Company.DataBind();
    //    Pager.RecordCount = Counts;
    //    page = Pager.CurrentPageIndex.ToString();
    //}

    public void BinDisUser()
    {
        int       pageCount    = 0;
        int       Counts       = 0;
        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(Pager.PageSize, Pager.CurrentPageIndex, "SYS_CompUser.createdate", false, "SYS_CompUser.id,SYS_CompUser.userid,SYS_CompUser.RoleId,UserName,SYS_CompUser.createdate,TrueName,Phone,Identitys,Email,SYS_CompUser.IsEnabled ", JoinTableStr, SearchWhere(), out pageCount, out Counts);

        this.Rpt_Company.DataSource = LUser;
        this.Rpt_Company.DataBind();
        page = Pager.CurrentPageIndex.ToString();
    }
Esempio n. 16
0
    public void DataBinds()
    {
        Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(CompID);
        if (comp != null)
        {
            if (comp.ShortName == "" && comp.CompName.Length <= 12)
            {
                txtShortName.Value = comp.CompName;
            }
            else
            {
                txtShortName.Value = comp.ShortName;
            }
            txtOrcode.Value            = comp.OrganizationCode;
            txtCompName.Value          = comp.CompName;
            lblCompCode.InnerText      = comp.CompCode;
            txtTel.Value               = comp.Tel;
            txtZip.Value               = comp.Zip;
            txtFax.Value               = comp.Fax;
            txtLicence.Value           = comp.creditCode;
            txtAccount.Value           = comp.Account;
            txtAddress.Value           = comp.Address;
            txtLegal.Value             = comp.Legal;
            txtIdentitys.Value         = comp.Identitys;
            txtPrincipal.Value         = comp.Principal;
            txtPhone.Value             = comp.Phone;
            txtInfo.Value              = comp.ManageInfo;
            txtLegalTel.Value          = comp.LegalTel;
            txtIndusName.SelectedValue = comp.IndID.ToString();
            QQ.Value = comp.QQ;
            if (comp.HotShow == 0)
            {
                rdHotShowNo.Checked  = true;
                rdHotShowYes.Checked = false;
            }

            //txtFinanceCode.Value = comp.FinanceCode.ToString();
            //txtFinanceName.Value = comp.FinanceName.ToString();
            List <Hi.Model.SYS_CompUser> user2 = new Hi.BLL.SYS_CompUser().GetList("", "  isnull(dr,0)=0 and  compid='" + CompID + "' and utype=4", "");
            if (user2.Count > 0)
            {
                Hi.Model.SYS_Users user = new Hi.BLL.SYS_Users().GetModel(user2[0].UserID);

                if (user != null)
                {
                    txtUsername.Disabled  = true;
                    txtUserPhone.Disabled = true;
                    txtUsername.Value     = user.UserName;
                    txtUserPhone.Value    = user.Phone;
                    txtUserTrueName.Value = user.TrueName;
                }
            }
        }
    }
Esempio n. 17
0
    protected void btn_NUse(object sender, EventArgs e)
    {
        List <Hi.Model.SYS_Role> ListRole = new Hi.BLL.SYS_Role().GetList("", " dr=0 and id=" + KeyID + " and DisID=" + DisID + " ", "");

        if (ListRole.Count > 0)
        {
            if (ListRole[0].RoleName == "企业管理员")
            {
                JScript.AlertMsgOne(this, "代理商管理员岗位不允许禁用!", JScript.IconOption.错误);
                return;
            }
        }
        else
        {
            JScript.AlertMsgOne(this, "禁用的岗位不存在!", JScript.IconOption.错误);
            return;
        }

        SqlTransaction Tran = null;

        try
        {
            Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
            List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and RoleID=" + ListRole[0].ID + " and Disid=" + DisID + " and  Ctype=2 ", "");
            foreach (Hi.Model.SYS_CompUser model in ListCompUser)
            {
                model.IsEnabled  = 0;
                model.ts         = DateTime.Now;
                model.modifyuser = UserID;
                new Hi.BLL.SYS_CompUser().Update(model, Tran);
            }
            Tran.Commit();
        }
        catch
        {
            if (Tran != null)
            {
                if (Tran.Connection != null)
                {
                    Tran.Rollback();
                }
                JScript.AlertMethod(this, "操作失败!", JScript.IconOption.错误, "function(){ window.location.href=window.location.href; }");
            }
        }

        ListRole[0].IsEnabled  = 0;
        ListRole[0].ts         = DateTime.Now;
        ListRole[0].modifyuser = UserID;
        if (new Hi.BLL.SYS_Role().Update(ListRole[0]))
        {
            Response.Redirect("RoleList.aspx");
        }
    }
Esempio n. 18
0
    public void Databind()
    {
        Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
        if (Dis != null)
        {
            hidProvince.Value     = Dis.Province;
            hidCity.Value         = Dis.City;
            hidArea.Value         = Dis.Area;
            txtDisName.Value      = Dis.DisName;
            txtLicence.Value      = Dis.Licence;
            txtTel.Value          = Dis.Tel;
            txtname.Value         = Dis.Principal;
            txtnamephone.Value    = Dis.Phone;
            txtZip.Value          = Dis.Zip;
            txtFax.Value          = Dis.Fax;
            txtAddress.Value      = Dis.Address;
            txtLeading.Value      = Dis.Leading;
            txtLeadingPhone.Value = Dis.LeadingPhone;
            List <Hi.Model.SYS_CompUser> user2 = new Hi.BLL.SYS_CompUser().GetList("", "  isnull(dr,0)=0 and  disId='" + this.DisID + "' and utype=5", "");
            if (user2.Count > 0)
            {
                Hi.Model.SYS_Users u = new Hi.BLL.SYS_Users().GetModel(user2[0].UserID);

                if (u != null)
                {
                    //List<Hi.Model.SYS_Users> u = new Hi.BLL.SYS_Users().GetList("", "  isnull(dr,0)=0 and  DisID='" + this.DisID + "' and type=5", "");
                    //if (u.Count > 0)
                    //{
                    txtUsername.Disabled  = true;
                    txtUserPhone.Disabled = true;
                    txtUsername.Value     = u.UserName;
                    txtUserPhone.Value    = u.Phone;
                    txtUserTrueName.Value = u.TrueName;
                }
            }
            else
            {
                List <Hi.Model.SYS_Users> users = new Hi.BLL.SYS_Users().GetList("", " DisID='" + this.DisID + "'", "");

                if (users.Count > 0)
                {
                    //List<Hi.Model.SYS_Users> u = new Hi.BLL.SYS_Users().GetList("", "  isnull(dr,0)=0 and  DisID='" + this.DisID + "' and type=5", "");
                    //if (u.Count > 0)
                    //{
                    txtUsername.Disabled  = true;
                    txtUserPhone.Disabled = true;
                    txtUsername.Value     = users[0].UserName;
                    txtUserPhone.Value    = users[0].Phone;
                    txtUserTrueName.Value = users[0].TrueName;
                }
            }
        }
    }
Esempio n. 19
0
    public void UserDataBind()
    {
        int       pageCount    = 0;
        int       Counts       = 0;
        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(Pager.PageSize, Pager.CurrentPageIndex, "SYS_CompUser.createdate", false, " SYS_CompUser.id,UserName,SYS_CompUser.createdate,TrueName,Phone,Identitys,Email,SYS_CompUser.IsEnabled,utype Type,isaudit ", JoinTableStr, " and utype in(3,4) and ctype=1  and SYS_CompUser.compid=" + KeyID + " ", out pageCount, out Counts);

        this.Rpt_User.DataSource = LUser;
        this.Rpt_User.DataBind();
        Pager1.RecordCount = Counts;
        page1 = Pager1.CurrentPageIndex.ToString();
    }
Esempio n. 20
0
    protected void btn_NUse(object sender, EventArgs e)
    {
        Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID);
        string    sql    = "select * from SYS_CompUser where ISNULL(dr,0)=0 and DisID=" + KeyID;
        DataTable userDT = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0];

        if (userDT.Rows.Count > 0)
        {
            SqlTransaction Tran = null;
            try
            {
                Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
                for (int i = 0; i < userDT.Rows.Count; i++)
                {
                    Hi.Model.SYS_CompUser user = new Hi.BLL.SYS_CompUser().GetModel(Convert.ToInt32(userDT.Rows[i]["ID"].ToString()));
                    user.IsEnabled  = 0;
                    user.ts         = DateTime.Now;
                    user.modifyuser = UserID;
                    new Hi.BLL.SYS_CompUser().Update(user, Tran);
                }
                Tran.Commit();
            }
            catch
            {
                if (Tran != null)
                {
                    if (Tran.Connection != null)
                    {
                        Tran.Rollback();
                    }
                    JScript.AlertMethod(this, "操作失败!", JScript.IconOption.错误, "function(){ window.location.href=window.location.href; }");
                }
            }
        }
        if (Dis != null)
        {
            Dis.IsEnabled  = 0;
            Dis.ts         = DateTime.Now;
            Dis.modifyuser = UserID;
            if (new Hi.BLL.BD_Distributor().Update(Dis))
            {
                if (Request["nextstep"] + "" == "1")
                {
                    Response.Redirect("DisList.aspx?nextstep=1");
                }
                else
                {
                    Response.Redirect("DisInfo.aspx?KeyID=" + KeyID.ToString() + "&type=2");
                }
            }
        }
    }
Esempio n. 21
0
 protected void btn_Del(object sender, EventArgs e)
 {
     Hi.Model.SYS_CompUser user = new Hi.BLL.SYS_CompUser().GetModel(KeyID);
     if (user != null)
     {
         user.dr         = 1;
         user.modifyuser = UserID;
         user.ts         = DateTime.Now;
         if (new Hi.BLL.SYS_CompUser().Update(user))
         {
             JScript.AlertMethod(this, "用户删除成功!", JScript.IconOption.正确, "function(){ window.location.href='DisUserList.aspx'; }");
         }
     }
 }
Esempio n. 22
0
    public void EditOpenID(string JSon, string version)
    {
        try
        {
            string   openid     = string.Empty;
            string   CompUserID = string.Empty;
            JsonData JInfo      = JsonMapper.ToObject(JSon);
            if (JInfo.Count > 0 && JInfo["CompUserID"].ToString() != "")
            {
                openid     = JInfo["OpenID"].ToString().Trim();
                CompUserID = JInfo["CompUserID"].ToString().Trim();
            }
            else
            {
                return;
            }
            Hi.Model.SYS_CompUser compuser = new Hi.BLL.SYS_CompUser().GetModel(int.Parse(CompUserID));
            if (compuser == null || compuser.IsAudit != 2 || compuser.dr == 1 || compuser.IsEnabled != 1)
            {
                return;
            }
            Hi.BLL.SYS_Users   bll_user = new Hi.BLL.SYS_Users();
            Hi.Model.SYS_Users user     = bll_user.GetModel(compuser.UserID);
            if (user == null || user.AuditState != 2 || user.dr == 1 || user.IsEnabled != 1)
            {
                return;
            }

            if (openid == "")
            {
                user.OpenID = "";
            }
            else
            {
                user.OpenID = openid + "&&" + compuser.ID;
            }
            user.ts         = DateTime.Now;
            user.modifyuser = user.ID;



            bll_user.Update(user);
        }
        catch (Exception ex)
        {
            Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "EditOpenID:" + JSon);
            return;
        }
    }
Esempio n. 23
0
    protected void btn_Delete(object sender, EventArgs e)
    {
        List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("top 1 *", "   UserID=" + KeyID + " and DisID=" + DisID + " and ctype=2 ", "");

        if (ListCompUser.Count > 0)
        {
            if (ListCompUser[0].UType == 5)
            {
                JScript.AlertMsgOne(this, "该用户为管理员,不可删除!", JScript.IconOption.错误, 2500);
                return;
            }
            else
            {
                List <int> ListUserid    = new List <int>();
                List <int> ListDelUserid = new List <int>();
                foreach (Hi.Model.SYS_CompUser model in ListCompUser)
                {
                    if (!ListUserid.Contains(model.UserID))
                    {
                        List <Hi.Model.SYS_CompUser> luser = new Hi.BLL.SYS_CompUser().GetList("id", " dr=0 and Userid=" + model.UserID + " ", "");
                        if (luser.Count == 1)
                        {
                            ListDelUserid.Add(model.UserID);
                        }
                        ListUserid.Add(model.UserID);
                    }
                    model.dr         = 1;
                    model.ts         = DateTime.Now;
                    model.modifyuser = Common.UserID();
                    new Hi.BLL.SYS_CompUser().Update(model);
                }
                if (ListDelUserid.Count > 0)
                {
                    List <Hi.Model.SYS_Users> ListUsers = new Hi.BLL.SYS_Users().GetList("", " dr=0 and id in(" + string.Join(",", ListDelUserid) + ")", "");
                    foreach (Hi.Model.SYS_Users model in ListUsers)
                    {
                        model.dr         = 1;
                        model.ts         = DateTime.Now;
                        model.modifyuser = Common.UserID();
                        new Hi.BLL.SYS_Users().Update(model);
                    }
                }
                //this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "msg", "<script>window.parent.save();</script>");
                Response.Redirect("UsersList.aspx");
            }
        }
    }
Esempio n. 24
0
    /// <summary>
    /// 用户是否存在用户明细
    /// </summary>
    public static bool ExistRoleComp()
    {
        if (HttpContext.Current.Session != null)
        {
            if (HttpContext.Current.Session["UserModel"] is LoginModel)
            {
                LoginModel UserModel = HttpContext.Current.Session["UserModel"] as LoginModel;

                List <Hi.Model.SYS_CompUser> copmuserlist = new Hi.BLL.SYS_CompUser().GetList("", " isnull(dr,0)=0 and UserID=" + UserModel.UserID + " and CType=2 and IsAudit=2 and IsEnabled=1 and UType in(1,5)", "");

                if (copmuserlist != null && copmuserlist.Count > 0)
                {
                    return(true);
                }
            }
        }
        return(false);
    }
Esempio n. 25
0
    public void DataBind()
    {
        int       pageCount    = 0;
        int       Counts       = 0;
        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(1, 1, "SYS_CompUser.createdate", false, " Users.id,Users.Phone ", JoinTableStr, "  and SYS_CompUser.Compid=" + KeyID + " and Ctype=1 and Utype=4 ", out pageCount, out Counts);

        if (LUser.Rows.Count > 0)
        {
            txt_OldPhone.Value  = LUser.Rows[0]["Phone"].ToString();
            ViewState["Userid"] = LUser.Rows[0]["id"].ToString();
        }
        else
        {
            Response.Write("用户异常");
            Response.End();
        }
    }
Esempio n. 26
0
    public void DataBinds()
    {
        Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(CompID);
        if (comp != null)
        {
            lblShortName.InnerText = comp.ShortName;
            lblCompName.InnerText  = comp.CompName;
            lblCompCode.InnerText  = comp.CompCode;
            lblTel.InnerText       = comp.Tel;
            lblLicence.InnerText   = comp.creditCode;
            lblOrCode.InnerText    = comp.OrganizationCode;
            lblZip.InnerText       = comp.Zip;
            lblFax.InnerText       = comp.Fax;
            lblAccount.InnerText   = comp.Account;
            lblAddress.InnerText   = comp.Address;
            lblIndusName.Id        = comp.IndID.ToString();
            lblLegal.InnerText     = comp.Legal;
            lblIdentitys.InnerText = comp.Identitys;
            lblPrincipal.InnerText = comp.Principal;
            lblPhone.InnerText     = comp.Phone;
            lblInfo.InnerText      = comp.ManageInfo;
            lblLegalTel.InnerText  = comp.LegalTel;
            lblIsHot.InnerHtml     = comp.HotShow == 1 ? "是" : "<i style='color:red;'>否</i>";
            QQ.InnerHtml           = comp.QQ;
            //lblFinanceCode.InnerText = comp.FinanceCode;
            //lblFinanceName.InnerText = comp.FinanceName;
            List <Hi.Model.SYS_CompUser> user2 = new Hi.BLL.SYS_CompUser().GetList("", "  isnull(dr,0)=0 and  compid='" + CompID + "' and utype=4", "");
            if (user2.Count > 0)
            {
                Hi.Model.SYS_Users user = new Hi.BLL.SYS_Users().GetModel(user2[0].UserID);

                if (user != null)
                {
                    //List<Hi.Model.SYS_Users> user = new Hi.BLL.SYS_Users().GetList("", "  isnull(dr,0)=0 and  compid='" + CompID + "' and type=4", "");
                    // if (user.Count > 0)
                    // {
                    lblUsername.InnerText     = user.UserName;
                    lblUserPhone.InnerText    = user.Phone;
                    lblUserTrueName.InnerText = user.TrueName;
                }
            }
        }
    }
Esempio n. 27
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(KeyID);
     if (comp != null)
     {
         comp.Tel            = Common.NoHTML(txtTel.Value.Trim());
         comp.Zip            = Common.NoHTML(txtZip.Value.Trim());
         comp.Fax            = Common.NoHTML(txtFax.Value.Trim());
         comp.Principal      = Common.NoHTML(txtPrincipal.Value.Trim());
         comp.Address        = Common.NoHTML(txtAddress.Value.Trim());
         comp.CompLogo       = Common.NoHTML(HDCompPath.Value);
         comp.ShopLogo       = Common.NoHTML(HdShopLogoPath.Value);
         comp.CompNewLogo    = Common.NoHTML(HdNewShopLogoPath.Value);
         comp.CustomCompinfo = txtCustomInfo.Text;
         if (txtPhone.Value.Trim() == "")
         {
             List <Hi.Model.SYS_CompUser> User2 = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and utype=4 and CompID=" + KeyID + "", "");
             if (User2.Count > 0)
             {
                 Hi.Model.SYS_Users User = new Hi.BLL.SYS_Users().GetModel(User2[0].UserID);
                 if (User != null)
                 {
                     comp.Phone = User.Phone;
                 }
             }
             //List<Hi.Model.SYS_Users> User = new Hi.BLL.SYS_Users().GetList("", " dr=0 and type=4 and CompID=" + KeyID + "", "");
             //if (User.Count > 0)
             //{
             //    comp.Phone = User[0].Phone;
             //}
         }
         else
         {
             comp.Phone = Common.NoHTML(txtPhone.Value.Trim());
         }
         if (new Hi.BLL.BD_Company().Update(comp))
         {
             Response.Redirect("CompFixture.aspx?KeyID=" + KeyID);
         }
     }
 }
Esempio n. 28
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(CompID);
     if (comp != null)
     {
         comp.Tel       = Common.NoHTML(txtTel.Value.Trim());
         comp.Fax       = Common.NoHTML(txtFax.Value.Trim());
         comp.Principal = Common.NoHTML(txtPrincipal.Value.Trim());
         comp.Address   = Common.NoHTML(txtAddress.Value.Trim());
         if (txtPhone.Value.Trim() != "")
         {
             comp.Phone = Common.NoHTML(txtPhone.Value.Trim());
         }
         else
         {
             List <Hi.Model.SYS_CompUser> User2 = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and utype=4 and CompID=" + CompID + "", "");
             if (User2.Count > 0)
             {
                 Hi.Model.SYS_Users User = new Hi.BLL.SYS_Users().GetModel(User2[0].UserID);
                 if (User != null)
                 {
                     comp.Phone = Common.NoHTML(User.Phone);
                 }
             }
         }
         comp.BrandInfo      = Common.NoHTML(this.BrandIfon.Value.Trim());
         comp.CompLogo       = Common.NoHTML(HDCompPath.Value);
         comp.CustomCompinfo = txtCustomInfo.Text;
         if (new Hi.BLL.BD_Company().Update(comp))
         {
             if (Request["nextstep"] + "" == "1")
             {
                 JScript.AlertMethod(this, "恭喜您成功入驻医站通,您的商城您做主,尽情享受您的电商之旅吧!", JScript.IconOption.笑脸, "function () { onlinkOrder('../newOrder/orderBuy.aspx', 'dkxd') }");
             }
             else
             {
                 Response.Redirect("CompInfo.aspx");
             }
         }
     }
 }
Esempio n. 29
0
 protected void btn_NEnabled(object sender, EventArgs e)
 {
     Hi.Model.SYS_CompUser user = new Hi.BLL.SYS_CompUser().GetModel(KeyID);
     if (user != null)
     {
         if (user.IsEnabled == 1)
         {
             user.IsEnabled  = 0;
             user.modifyuser = UserID;
             user.ts         = DateTime.Now;
             if (new Hi.BLL.SYS_CompUser().Update(user))
             {
                 JScript.AlertMethod(this, "用户禁用成功", JScript.IconOption.正确, "function(){ window.location.href=window.location.href; }");
             }
         }
         else
         {
             JScript.AlertMethod(this, "用户已是禁用状态!", JScript.IconOption.错误, "function(){ window.location.href=window.location.href; }");
         }
     }
 }
Esempio n. 30
0
    public void UserDataBind()
    {
        int       pageCount    = 0;
        int       Counts       = 0;
        string    JoinTableStr = " SYS_CompUser inner join Sys_Users Users on  SYS_CompUser.userid=Users.id and isnull(SYS_CompUser.dr,0)=0 and isnull(Users.dr,0)=0 ";
        DataTable LUser        = new Hi.BLL.SYS_CompUser().GetList(Pager.PageSize, Pager.CurrentPageIndex, "SYS_CompUser.createdate", false, " SYS_CompUser.id,UserName,SYS_CompUser.CompID,SYS_CompUser.createdate,TrueName,Phone,Identitys,Email,SYS_CompUser.IsEnabled,utype Type,isaudit ", JoinTableStr, " and utype in(1,5) and ctype=2  and SYS_CompUser.Disid=" + KeyID + " ", out pageCount, out Counts);

        if (LUser.Rows.Count > 0)
        {
            this.Rpt_User.DataSource = LUser;
            this.Rpt_User.DataBind();
            Pager.RecordCount = Counts;
            page = Pager.CurrentPageIndex.ToString();
        }
        else
        {
            List <Hi.Model.SYS_Users> LUser2 = new Hi.BLL.SYS_Users().GetList(" UserName,TrueName,auditstate,5 Type,Phone ", " isnull(dr,0)=0 and disid=" + KeyID + "", "");
            this.Rpt_User.DataSource = LUser2;
            this.Rpt_User.DataBind();
            Pager.RecordCount = Counts;
            page = Pager.CurrentPageIndex.ToString();
        }
    }