Ejemplo n.º 1
0
        /// <summary>
        /// 得到会员信息
        /// </summary>
        /// <param name="phone"></param>
        /// <returns></returns>
        public MemberInfoModel GetMember(string phone)
        {
            string sqltxt = @"SELECT  ID ,
        TruethName ,
        MobileNum,MStatus
FROM    dbo.MemberInfo
WHERE   MobileNum = @MobileNum";

            SqlParameter[] paramter =
            {
                new SqlParameter("@MobileNum", phone)
            };
            DataTable dt = helper.Query(sqltxt, paramter).Tables[0];

            if (dt.Rows.Count > 0)
            {
                MemberInfoModel model = new MemberInfoModel();
                model.ID         = int.Parse(dt.Rows[0]["ID"].ToString());
                model.TruethName = dt.Rows[0]["TruethName"].ToString();
                model.MobileNum  = dt.Rows[0]["MobileNum"].ToString();
                model.MStatus    = dt.Rows[0]["MStatus"].ToString().ParseToInt(1);
                return(model);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 得到会员信息
        /// </summary>
        /// <param name="phone"></param>
        /// <returns></returns>
        public MemberInfoModel GetMember(int mid)
        {
            string sqltxt = @"SELECT  ID ,
        TruethName ,
        MobileNum
FROM    dbo.MemberInfo
WHERE   ID = @Mid";

            SqlParameter[] paramter =
            {
                new SqlParameter("@Mid", mid)
            };
            DataTable dt = helper.Query(sqltxt, paramter).Tables[0];

            if (dt.Rows.Count > 0)
            {
                MemberInfoModel model = new MemberInfoModel();
                model.ID         = int.Parse(dt.Rows[0]["ID"].ToString());
                model.TruethName = dt.Rows[0]["TruethName"].ToString();
                model.MobileNum  = dt.Rows[0]["MobileNum"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 接受帮助单据信息页面
        /// </summary>
        /// <param name="orderid"></param>
        /// <returns></returns>
        public ActionResult AcceptOrderDetail(int orderid)
        {
            MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;

            if (logmember == null)
            {
                return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
            }
            AcceptOrderViewModel model = new AcceptOrderViewModel();
            AcceptHelpOrderModel order = aobll.GetAcceptOrderInfo(orderid, logmember.ID);

            if (order == null)
            {
                return(RedirectToAction("Index", "WebHome", new { area = "NewTemplateArea" }));
            }
            //本人的信息
            model.acceptpeople = logmember;
            //匹配列表单据信息和会员信息及推荐人联系方式
            List <HelpOrderExtendInfoModel> acceptmodel = aobll.GetHelpextendmodels(orderid);

            model.helpOrderInfo = acceptmodel;
            model.acceptorder   = order;
            ViewBag.PageTitle   = web.WebName;
            return(View(model));
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 得到该分配利息的会员
        /// </summary>
        /// <param name="day"></param>
        /// <returns></returns>
        public static List <MemberInfoModel> GetPaymentInterestMembers(int day)
        {
            List <MemberInfoModel> members = new List <MemberInfoModel>();
            string sqltxt = @"SELECT  MemberID ,
        b.MobileNum ,
        b.TruethName
FROM    dbo.MemberExtendInfo A
        INNER JOIN dbo.MemberInfo B ON A.MemberID = b.ID
WHERE   ( DATEDIFF(DAY, LastHelperTime, GETDATE()) + 1 ) <=@days";

            SqlParameter[] paramter =
            {
                new SqlParameter("@days", day)
            };
            DataTable dt = helper.Query(sqltxt, paramter).Tables[0];

            foreach (DataRow item in dt.Rows)
            {
                MemberInfoModel model = new MemberInfoModel();
                model.ID         = item["MemberID"].ToString().ParseToInt(0);
                model.TruethName = item["TruethName"].ToString();
                model.MobileNum  = item["MobileNum"].ToString();
            }
            return(members);
        }
Ejemplo n.º 5
0
    //绑定信息
    public void readInfo()
    {
        MemberInfoModel memberInfoModel = MemberInfoModifyBll.getMemberInfo(Session["Member"].ToString());


        DataTable dt = DetialQueryBLL.GetMemberInfoBalanceByNumber(ExpectNum, Session["Member"].ToString());

        if (dt.Rows.Count > 0)
        {
            lblNewPeople.Text = dt.Rows[0]["CurrentNewNetNum"].ToString();
            if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
            {
                lblNewYeji.Text         = "0.00";
                lblTotalYeji.Text       = "0.00";
                lblCurrentOneMark2.Text = "0.00";
                lblTotalOneMark2.Text   = "0.00";
            }
            else
            {
                lblNewYeji.Text         = (double.Parse(dt.Rows[0]["CurrentTotalNetRecord"].ToString())).ToString("0.00");
                lblTotalYeji.Text       = (double.Parse(dt.Rows[0]["TotalNetRecord"].ToString())).ToString("0.00");
                lblCurrentOneMark2.Text = (double.Parse(dt.Rows[0]["CurrentOneMark2"].ToString())).ToString("0.00");
                lblTotalOneMark2.Text   = (double.Parse(dt.Rows[0]["TotalOneMark2"].ToString())).ToString("0.00");
            }
            lblTotalPeople.Text = dt.Rows[0]["TotalNetNum"].ToString();
        }
    }
Ejemplo n.º 6
0
        /// <summary>
        /// 为会员分派奖金
        /// </summary>
        /// <param name="memberphone"></param>
        /// <param name="money"></param>
        /// <returns></returns>
        public string FenPaiMoney(string memberphone, decimal money)
        {
            string          result = "0";
            MemberInfoModel member = MemberInfoDAL.GetMember(memberphone);

            if (member == null)
            {
                return("0无此会员");
            }
            using (TransactionScope scope = new TransactionScope())
            {
                int rowcount = MemberCapitalDetailDAL.UpdateMemberDynamicFunds(member.ID, money, member.TruethName, member.MobileNum);
                if (rowcount < 1)
                {
                    return("0操作失败");
                }
                AmountChangeLogModel logmodel = new AmountChangeLogModel();
                logmodel.MemberID     = member.ID;
                logmodel.MemberName   = member.TruethName;
                logmodel.MemberPhone  = member.MobileNum;
                logmodel.OrderCode    = "";
                logmodel.OrderID      = 0;
                logmodel.ProduceMoney = money;
                logmodel.Remark       = "会员:" + member.MobileNum + " 得到系统派发的奖金";
                logmodel.Type         = 3;
                rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
                if (rowcount < 1)
                {
                    return("0操作失败");
                }
                scope.Complete();
                result = "1";
            }
            return(result);
        }
Ejemplo n.º 7
0
        /// <summary>
        /// 根据条件得到一个对象实体
        /// </summary>
        public Tz888.Model.Register.MemberInfoModel GetModel(string strCriteria)
        {
            DataTable dt = obj.GetList("MemberInfoTab", "*", "LoginName", 1, 1, 0, 1, strCriteria);

            Tz888.Model.Register.MemberInfoModel model = new MemberInfoModel();
            if (dt.Rows.Count > 0)
            {
                model.LoginName  = dt.Rows[0]["LoginName"].ToString();
                model.MemberName = dt.Rows[0]["MemberName"].ToString();
                if (dt.Rows[0]["Sex"].ToString() != "")
                {
                    if ((dt.Rows[0]["Sex"].ToString() == "1") || (dt.Rows[0]["Sex"].ToString().ToLower() == "true"))
                    {
                        model.Sex = true;
                    }
                    else
                    {
                        model.Sex = false;
                    }
                }

                model.NickName = dt.Rows[0]["NickName"].ToString();
                if (dt.Rows[0]["Birthday"].ToString() != "")
                {
                    model.Birthday = DateTime.Parse(dt.Rows[0]["Birthday"].ToString());
                }
                model.CertificateID     = dt.Rows[0]["CertificateID"].ToString();
                model.CertificateNumber = dt.Rows[0]["CertificateNumber"].ToString();
                model.CountryCode       = dt.Rows[0]["CountryCode"].ToString();
                model.ProvinceID        = dt.Rows[0]["ProvinceID"].ToString();
                model.CountyID          = dt.Rows[0]["CountyID"].ToString();
                model.Address           = dt.Rows[0]["Address"].ToString();
                model.PostCode          = dt.Rows[0]["PostCode"].ToString();
                model.Tel    = dt.Rows[0]["Tel"].ToString();
                model.Mobile = dt.Rows[0]["Mobile"].ToString();
                model.FAX    = dt.Rows[0]["FAX"].ToString();
                model.Email  = dt.Rows[0]["Email"].ToString();
                if (dt.Rows[0]["IsSecurity"].ToString() != "")
                {
                    if ((dt.Rows[0]["IsSecurity"].ToString() == "1") || (dt.Rows[0]["IsSecurity"].ToString().ToLower() == "true"))
                    {
                        model.IsSecurity = true;
                    }
                    else
                    {
                        model.IsSecurity = false;
                    }
                }

                model.ManageTypeID   = dt.Rows[0]["ManageTypeID"].ToString();
                model.RequirInfo     = dt.Rows[0]["RequirInfo"].ToString();
                model.RequirInfoDesc = dt.Rows[0]["RequirInfoDesc"].ToString();
                model.HeadPortrait   = dt.Rows[0]["HeadPortrait"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 8
0
        public void r107Implementation(MemberInfoModel instance)
        {
            // This is the placeholder for method implementation.

            if (Arguments.SelectedValues.Count() > 0)
            {
                string value = string.Join(",", ActionArgs.Current.SelectedValues);
                /// Result.NavigateUrl = String.Format("~/Pages/StudentPassword.aspx?ClassStudent={0}", value, false);
            }
            MailMessage message = new MailMessage();

            message.From = new MailAddress("*****@*****.**", "Sales, Code OnTime");

            // prepare smtp client
            SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);

            smtp.EnableSsl             = true;
            smtp.DeliveryMethod        = SmtpDeliveryMethod.Network;
            smtp.UseDefaultCredentials = false;
            smtp.Credentials           = new NetworkCredential("*****@*****.**", "kabir31bd@!#");

            // compose and send an email message

            // use CustomerID to find the recipient's email
            string sendTo = "*****@*****.**";

            //// message.Sender = "*****@*****.**";
            message.To.Add(sendTo);
            message.Subject = String.Format("Hello {0} at {1}.", instance.NameOfMember, instance.CellPhone);
            message.Body    = "Hello there!" + " My new Email Sender";
            smtp.Send(message);

            Result.ShowAlert("Email has been sent.");
        }
Ejemplo n.º 9
0
    /// <summary>
    /// 编辑基本信息
    /// </summary>
    public void editxtBasic()
    {
        txtEnumber.Visible        = false;
        txtEname.Visible          = true;
        txtEnickname.Visible      = true;
        txtEstore.Visible         = true;
        txtEIdtype.Visible        = true;
        txtEsex.Visible           = true;
        txtEbirthday.Visible      = true;
        txtEidnumber.Visible      = true;
        CountryCityPCode1.Visible = true;
        txtEaddress.Visible       = true;
        txtEcode.Visible          = true;
        txtEmethod.Visible        = true;
        txtEcurrency.Visible      = true;
        labenc.Visible            = true;

        lblEnumber.Visible   = true;
        lblEname.Visible     = false;
        lblEnickname.Visible = false;
        lblEstore.Visible    = false;
        lblEIdtype.Visible   = false;
        lblEsex.Visible      = false;
        lblEbirthday.Visible = false;
        lblEidnumber.Visible = false;
        lblEaddress.Visible  = false;
        lblEcode.Visible     = false;
        lblEmethod.Visible   = false;
        lblEcurrency.Visible = false;


        //tbephoto.Visible = true;
        //默认的会员编号是
        MemberInfoModel  model = MemInfoEditBLL.getMemberInfo(ViewState["membernumberE"].ToString());
        MemberOrderModel order = MemberOrderBLL.GetMemberOrder(model.OrderID);

        //绑定证件类型
        bindidtype();
        Translations();

        txtEnumber.Text   = model.Number;
        txtEname.Text     = Encryption.Encryption.GetDecipherName(model.Name);
        txtEnickname.Text = model.PetName;
        txtEstore.Text    = model.StoreID;
        try
        {
            txtEIdtype.SelectedValue = model.PaperType.PaperTypeCode.Trim();
        }
        catch (Exception exe1)
        {
            txtEIdtype.SelectedValue = "P000";
        }
        txtEsex.SelectedIndex = model.Sex == 0 ? 1 : 0;
        txtEbirthday.Text     = model.Birthday.ToString("yyyy-MM-dd");
        txtEidnumber.Text     = Encryption.Encryption.GetDecipherNumber(model.PaperNumber.ToString().Trim());
        CountryCityPCode1.SelectCountry(model.City.Country, model.City.Province, model.City.City, model.City.Xian);
        txtEaddress.Text  = Encryption.Encryption.GetDecipherAddress(model.Address.ToString().Trim());;
        txtEcode.Text     = model.PostalCode.ToString();
        lblEbankname.Text = Encryption.Encryption.GetDecipherName(model.BankBook);
    }
Ejemplo n.º 10
0
    /// <summary>
    /// 添加的时,绑定信息
    /// </summary>
    private void AddBind()
    {
        //购货店铺,默认为注册店铺
        TxtStore.Text = GetStoreId();
        //绑定产品树
        ProductTree myTree = new ProductTree();

        this.menuLabel.Text = myTree.getMemberProductList(GetStoreId());

        //绑定会员信息
        MemberInfoModel mi = MemberInfoModifyBll.getMemberInfo(GetMember());

        lblNumber.Text    = mi.Number;
        lblName.Text      = Encryption.Encryption.GetDecipherName(mi.Name);
        this.Txtxm.Text   = Encryption.Encryption.GetDecipherName(mi.Name);
        this.Txtyb.Text   = mi.PostalCode;
        this.Email.Text   = mi.Email;
        this.Txtjtdh.Text = Encryption.Encryption.GetDecipherTele(mi.HomeTele);
        this.Txtyddh.Text = Encryption.Encryption.GetDecipherTele(mi.MobileTele);
        //this.CountryCity1.SelectCountry(mi.City.Country, mi.City.Province, mi.City.City,mi.City.Xian);
        //this.Txtdz.Text = Encryption.Encryption.GetDecipherAddress(mi.Address);

        //this.rdPayType.Enabled = true;
        //this.rdPayType.AutoPostBack = true;
        //this.dzpanel.Visible = false;
    }
Ejemplo n.º 11
0
    /// <summary>
    /// 查看联系信息
    /// </summary>
    public void SellblContact()
    {
        lblEmobile.Visible   = true; //移动电话
        lblEphone.Visible    = true; //家庭电话
        lblEfax.Visible      = true; //传真电话
        lblEOffphone.Visible = true; //办公电话
        lblEemail.Visible    = true; //Email

        this.divBg.Visible      = false;
        this.divCz.Visible      = false;
        this.divJt.Visible      = false;
        this.txtEmobile.Visible = false;
        this.txtEemail.Visible  = false;
        //this.TxtjtdhQh.Visible = false;
        //Txtjtdh.Visible = false;//家庭电话
        //this.TxtczdhQh.Visible = false;
        //Txtczdh.Visible = false;//传真电话
        //this.TxtbgdhFj.Visible = false;
        //this.TxtbgdhQh.Visible = false;
        //Txtbgdh.Visible = false;//办公电话
        //this.TxtbgdhFj.Visible = false;


        //默认的会员编号是8888888888s
        MemberInfoModel model = MemInfoEditBLL.getMemberInfo(ViewState["membernumberE"].ToString());

        //MemberOrderModel order = MemberOrderBLL.GetMemberOrder(model.OrderID);

        lblEmobile.Text   = Encryption.Encryption.GetDecipherTele(model.MobileTele);
        lblEphone.Text    = Encryption.Encryption.GetDecipherTele(model.HomeTele);
        lblEfax.Text      = Encryption.Encryption.GetDecipherTele(model.FaxTele);
        lblEOffphone.Text = Encryption.Encryption.GetDecipherTele(model.OfficeTele);
        lblEemail.Text    = model.Email;
    }
Ejemplo n.º 12
0
        public ActionResult AddacceptReporting(int orderid, string reason, string title, string text)
        {
            MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;

            if (logmember == null)
            {
                return(RedirectToAction("Index", "Login", new { area = "WebFrontArea" }));
            }
            OrderReportingModel model = new OrderReportingModel();

            model.OrderID       = orderid;
            model.MemberID      = logmember.ID;
            model.MemberName    = logmember.TruethName;
            model.MemberPhone   = logmember.MobileNum;
            model.Title         = title;
            model.ReportingText = text;
            model.ReasonType    = reason;
            int row = reportbll.AddReportForAcceptDetail(model);

            if (row > 0)
            {
                return(Json("1"));
            }
            else
            {
                return(Json("0"));
            }
        }
Ejemplo n.º 13
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        SearchCodeInfo search = new SearchCodeInfo();
        string         ticket = search.GetAuthorizationTicket("xingzhen", "xz20100722");
        JgdmInfo       info   = search.GetJgdmDetail(ticket, txtjgdm.Text.Trim().Replace("-", "").Replace("-", ""));

        if (info.State == "000001")
        {
            MemberInfoModel model = new MemberInfoModel();

            if (checkUsername(KillSqlIn.Form_ReplaceByString(this.txtname.Text, 20)) == "0")
            {
                model.memberName        = KillSqlIn.Form_ReplaceByString(this.txtname.Text, 20);
                model.password          = KillSqlIn.Form_ReplaceByString(this.txtpw.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密
                model.memberLevel       = "20";
                model.memberType        = type;
                model.memberCompanyType = "";
                model.areaName          = "";
                model.memberCompanyName = info.jgmc;
                model.memberCompanyCode = txtjgdm.Text;
                model.memberTrueName    = "";
                model.sex                  = "";
                model.tel                  = "";
                model.fax                  = "";
                model.mobile               = "";
                model.address              = "";
                model.post                 = "";
                model.email                = "";
                model.regTime              = System.DateTime.Now;
                model.shFlag               = 1;
                model.shTime               = DateTime.Now;
                model.shPerson             = "SYS";
                model.unPassReason         = "";
                model.memberStatus         = "ZC";//正常:ZC  禁用:JY
                model.buyMoneyAccount      = 0;
                model.buyMoneyAccountUsed  = 0;
                model.freeMoenyAccount     = 0;
                model.freeMoenyAccountUsed = 0;
                int i = new MemberInfoBLL().Add(model);
                if (i > 0)
                {
                    Session["MemberId"] = i.ToString();
                    Response.Write("<script>alert('注册成功!');layer_close();</script>");
                }
                else
                {
                    Response.Write("<script>alert('注册失败!');</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('该用户名已存在!');layer_close();</script>");
            }
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('组织机构代码错误!');</script>");
            return;
        }
    }
Ejemplo n.º 14
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Permissions.MemRedirect(Page, Permissions.redirUrl);
     if (!IsPostBack)
     {
         try
         {
             type = Request.QueryString["type"] == "" ? "" : Request.QueryString["type"];
             url  = Request.QueryString["url"] == "" ? "" : Request.QueryString["url"];
             var Member = Session["Member"];
             if (Member != null)
             {
                 MemberInfoModel member = MemInfoEditBLL.getMemberInfo(Member.ToString());
                 if (member != null)
                 {
                     txtzhifubao.Text = member.Zhifubao;
                     txtName.Text     = member.Name;
                 }
             }
             else
             {
                 Response.Redirect("../index.aspx");
             }
         }
         catch (Exception ex)
         {
             Response.Redirect("../index.aspx");
         }
     }
 }
Ejemplo n.º 15
0
    /// <summary>
    /// 编辑帐户信息
    /// </summary>
    public void edilblBank()
    {
        lblEbankname.Visible    = true;  //开户名
        lblEbank.Visible        = false; //开户银行
        lblEbanknumber.Visible  = false; //银行卡号
        lblEbankaddress.Visible = false; //银行地址

        CcpEbankaddress.Visible   = true;
        plEbank.Visible           = true; //开户银行
        txtEbanknumber.Visible    = true; //银行卡号
        txtEbankaddress.Visible   = true; //银行地址
        CountryCityPCode2.Visible = true;

        //默认的会员编号是8888888888s
        MemberInfoModel model = MemInfoEditBLL.getMemberInfo(ViewState["membernumberE"].ToString());

        txtEbank.Text         = model.Bankbranchname;
        ViewState["bankcode"] = model.BankCode;
        txtEbanknumber.Text   = Encryption.Encryption.GetDecipherCard(model.BankCard);
        CityModel cityM = CommonDataDAL.GetCPCCode(model.BCPCCode);

        CountryCityPCode2.SelectCountry(cityM.Country, cityM.Province, cityM.City, cityM.Xian);
        txtEbankaddress.Text = Encryption.Encryption.GetDecipherAddress(model.BankAddress);
        BindCountry();
    }
Ejemplo n.º 16
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        MemberInfoModel _mod = new MemberInfoModel();
        MemberInfoBLL   bll  = new MemberInfoBLL();

        _mod = bll.GetModel(userid);
        if (_mod != null)
        {
            _mod.shFlag            = Convert.ToInt32(this.rdlshFlag.SelectedValue);
            _mod.shPerson          = this.txtshPerson.Text;
            _mod.shTime            = Convert.ToDateTime(this.txtshTime.Value);
            _mod.unPassReason      = this.txtunPassReason.Text;
            _mod.memberStatus      = this.rdlmemberStatus.SelectedValue;
            _mod.memberCompanyType = GetHyType();
            if ((bll.Update(_mod)) > 0)
            {
                string BackUrl = "MemberList.aspx?PageIndex=" + PageIndex;
                /*日志归档*/
                string sql = @"select memberName as title from T_Member_Info u where memberId=" + userid + "";
                PubFunction.InsertLog("业务管理", "会员管理", "会员列表", "修改", sql, userid.ToString());

                ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('操作成功!');layer_close();</script>");
            }
        }
    }
Ejemplo n.º 17
0
        /// <summary>
        /// 接受帮助列表页面
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        public ActionResult acceptOrderlist(AcceptHelpOrderModel seachmodel, int page = 1)
        {
            MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;

            if (logmember == null)
            {
                return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
            }
            AcceptOrderListViewModel model = new AcceptOrderListViewModel();
            int totalcount = 0;

            seachmodel.MemberID  = logmember.ID;
            seachmodel.PageIndex = page;
            seachmodel.PageSize  = pagesize;
            List <AcceptHelpOrderModel>      orderlist = aobll.GetAllAcceptOrderListForPage(seachmodel, out totalcount);
            PagedList <AcceptHelpOrderModel> pagelist  = null;

            if (orderlist != null)
            {
                pagelist = new PagedList <AcceptHelpOrderModel>(orderlist, page, pagesize, totalcount);
            }
            model.orderlist   = pagelist;
            ViewBag.PageTitle = web.WebName;
            return(View(model));
        }
Ejemplo n.º 18
0
    public void LoadDataAAA()
    {
        int tp = 0;

        if (Request.QueryString["tp"] != null)
        {
            try
            {
                tp = Convert.ToInt32(Request.QueryString["tp"]);
            }
            catch {
                tp = 0;
            }
        }
        Session["cpage"] = tp;

        string  number     = Session["member"].ToString();
        decimal todayprice = Common.GetnowPrice();

        hidprice.Value     = todayprice.ToString("0.0000");
        mrjg.Text          = todayprice.ToString("0.0000");
        mcjg.Text          = todayprice.ToString("0.0000");
        lbltodayprice.Text = todayprice.ToString("0.0000");
        MemberInfoModel mb = MemberInfoDAL.getMemberInfo(number);
        decimal         de = Convert.ToDecimal(DBHelper.ExecuteScalar("select para15  from config where ExpectNum=" + CommonDataBLL.getMaxqishu() + "  "));

        lblzzlv.Text = (de * 100).ToString("0.00") + "%";


        decimal ca   = 0;
        decimal usdt = 0;

        DataTable dt = DBHelper.ExecuteDataTable("select  jackpot-out-membership  as usdt ,pointAin-pointAout-pointAfz as ca from memberinfo where number='" + number + "'");

        if (dt != null && dt.Rows.Count > 0)
        {
            DataRow dr = dt.Rows[0];
            ca   = Convert.ToDecimal(dr["ca"]);
            usdt = Convert.ToDecimal(dr["usdt"]);
        }

        decimal sxfbl = Common.GetSxfWyjblv(0);
        decimal wyjbl = Common.GetSxfWyjblv(1);

        //decimal wyjjb = blace*wyjbl; //违约金石斛积分数量
        //decimal sxfjb =sxfbl*blace ;  //手续费石斛积分数量

        hidblance.Value = ca.ToString("0.0000");    ///卖出数量余额

        sellsz.Text = "0";
        //  lblmaxsell.Text = (blace / (1 + sxfbl + wyjbl)).ToString("0.00");

        mairu            = Convert.ToInt32(usdt / todayprice).ToString();
        qbye.Text        = mairu;
        hidusdtblc.Value = usdt.ToString("0.0000");


        //MobileTele.Value = mb.MobileTele;
    }
Ejemplo n.º 19
0
 public ActionResult EditMember(MemberInfoModel member)
 {
     if (member != null)
     {
         bool row = bll.UpdateMemberInfo(member);
     }
     return(RedirectToActionPermanent("Index", "MemberOpera", new { area = "AdminArea" }));
 }
Ejemplo n.º 20
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int AddMemberInfo(MemberInfoModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into MemberInfo(");
            strSql.Append("Area,Address,WeixinNum,AliPayName,AliPayNum,SecurityQuestion,SecurityAnswer,LogPwd,MStatus,AddTime,TruethName,Sex,TelPhone,MobileNum,Email,IdentificationID,Province,City");
            strSql.Append(") values (");
            strSql.Append("@Area,@Address,@WeixinNum,@AliPayName,@AliPayNum,@SecurityQuestion,@SecurityAnswer,@LogPwd,1,GETDATE(),@TruethName,@Sex,@TelPhone,@MobileNum,@Email,@IdentificationID,@Province,@City");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Area",             SqlDbType.NVarChar),
                new SqlParameter("@Address",          SqlDbType.NVarChar),
                new SqlParameter("@WeixinNum",        SqlDbType.NVarChar),
                new SqlParameter("@AliPayName",       SqlDbType.NVarChar),
                new SqlParameter("@AliPayNum",        SqlDbType.NVarChar),
                new SqlParameter("@SecurityQuestion", SqlDbType.NVarChar),
                new SqlParameter("@SecurityAnswer",   SqlDbType.NVarChar),
                new SqlParameter("@LogPwd",           SqlDbType.NVarChar),
                new SqlParameter("@TruethName",       SqlDbType.NVarChar),
                new SqlParameter("@Sex",              SqlDbType.Int),
                new SqlParameter("@TelPhone",         SqlDbType.NVarChar),
                new SqlParameter("@MobileNum",        SqlDbType.NVarChar),
                new SqlParameter("@Email",            SqlDbType.NVarChar),
                new SqlParameter("@IdentificationID", SqlDbType.NVarChar),
                new SqlParameter("@Province",         SqlDbType.NVarChar),
                new SqlParameter("@City",             SqlDbType.NVarChar)
            };
            parameters[0].Value  = model.Area;
            parameters[1].Value  = model.Address;
            parameters[2].Value  = model.WeixinNum;
            parameters[3].Value  = model.AliPayName;
            parameters[4].Value  = model.AliPayNum;
            parameters[5].Value  = model.SecurityQuestion;
            parameters[6].Value  = model.SecurityAnswer;
            parameters[7].Value  = model.LogPwd;
            parameters[8].Value  = model.TruethName;
            parameters[9].Value  = model.Sex;
            parameters[10].Value = model.TelPhone;
            parameters[11].Value = model.MobileNum;
            parameters[12].Value = model.Email;
            parameters[13].Value = model.IdentificationID;
            parameters[14].Value = model.Province;
            parameters[15].Value = model.City;

            object obj = helper.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Ejemplo n.º 21
0
        /// <summary>
        /// 调用存储过程
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int InsertMemberInfo(MemberInfoModel model, SqlTransaction tran)
        {
            //SqlTransaction tran = null;
            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@Number", model.Number),
                new SqlParameter("@Placement", model.Placement),
                new SqlParameter("@Recommended", model.Direct),
                new SqlParameter("@ExpectNum", model.ExpectNum),
                new SqlParameter("@OrderID", model.OrderID),
                new SqlParameter("@StoreID", model.StoreID),
                new SqlParameter("@Name", model.Name),
                new SqlParameter("@PetName", model.PetName),
                new SqlParameter("@LoginPass", model.LoginPass),
                new SqlParameter("@Advpass", model.AdvPass),
                //new SqlParameter("@LevelStr", model.LevelStr),
                new SqlParameter("@LevelInt", model.LevelInt),
                new SqlParameter("@RegisterDatec", model.RegisterDate),
                new SqlParameter("@Birthday", model.Birthday),
                new SqlParameter("@Sex", model.Sex),
                new SqlParameter("@HomeTele", model.HomeTele),
                new SqlParameter("@OfficeTele", model.OfficeTele),
                new SqlParameter("@MobileTele", model.MobileTele),
                new SqlParameter("@FaxTele", model.FaxTele),
                //new SqlParameter("@Country", model.Country),
                //new SqlParameter("@Province", model.Province),
                //new SqlParameter("@City", model.City),
                new SqlParameter("@CPCCode", model.CPCCode),
                new SqlParameter("@Address", model.Address),
                new SqlParameter("@PostalCode", model.PostalCode),
                new SqlParameter("@PaperTypeCode", model.PaperType.PaperTypeCode),
                new SqlParameter("@PaperNumber", model.PaperNumber),
                new SqlParameter("@BankCode", model.BankCode),
                new SqlParameter("@BankAddress", model.BankAddress),
                new SqlParameter("@BankCard", model.BankCard),
                //new SqlParameter("@BankCountry", model.BankCountry),
                //new SqlParameter("@BankProvince", model.BankProvince),
                //new SqlParameter("@BankCity", model.BankCity),
                new SqlParameter("@BCPCCode", model.BCPCCode),
                new SqlParameter("@BankBook", model.BankBook),
                new SqlParameter("@Remark", model.Remark),
                new SqlParameter("@ChangeInfo", model.ChangeInfo),
                new SqlParameter("@Photopath", model.PhotoPath),
                new SqlParameter("@Email", model.Email),
                new SqlParameter("@IsBatch", model.IsBatch),
                new SqlParameter("@Language", model.Language),
                new SqlParameter("@OperateIP", model.OperateIp),
                new SqlParameter("@OperaterNumber", model.OperaterNum),
                new SqlParameter("@District", model.District),
                new SqlParameter("@Answer", model.Answer),
                new SqlParameter("@Question", model.Question),
                new SqlParameter("@Err", model.Error),
                new SqlParameter("@BankBranchName", model.Bankbranchname),
            };

            return(DBHelper.ExecuteNonQuery(tran, "UP_MemberInfo_ADD", para, CommandType.StoredProcedure));
        }
Ejemplo n.º 22
0
    public int insertData(string loginName, byte[] passWord2, string email, string nikeName, string tel, string addr, string infoid, string sitekey)
    {
        int flag = 0;

        LoginInfoModel model = new LoginInfoModel();

        model.LoginName     = loginName;
        model.Password      = passWord2;
        model.NickName      = nikeName;
        model.RoleName      = "0";//会员
        model.ManageTypeID  = "2002";
        model.MemberGradeID = "1001";
        model.IsCheckUp     = false;
        model.Email         = email;
        model.Tel           = tel;
        model.CompanyName   = addr;
        model.PropertyID    = Int32.Parse("0");
        //--------会员信息
        MemberInfoModel memberModel = new MemberInfoModel();

        memberModel.LoginName    = loginName;
        memberModel.ManageTypeID = "2002";
        memberModel.NickName     = nikeName;
        memberModel.Email        = email;
        memberModel.Tel          = tel;
        memberModel.Mobile       = "";
        memberModel.Birthday     = DateTime.Now;

        LoginInfoBLL  loginfo = new LoginInfoBLL();
        MemberInfoBLL member  = new MemberInfoBLL();

        try
        {
            try
            {
                loginfo.LogInfoAdd(model);                                 //向注册表写数据
                loc.AdLogin_Add2(model.LoginName.Trim(), infoid, sitekey); //向AdLoginInfoTab表写数据
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                throw (new Exception(ex.Message));
            }
            int i = member.MemberMessage_Insert(memberModel);   //会员信息
            if (i > 0)
            {
                //BBS_Reg.Reg(nikeName, "123456", email);         //论坛会员注册
                flag = 1;
            }
        }
        catch (Exception exp)
        {
            flag = -1;
            Tz888.Common.MessageBox.ShowBack("数据提交时出错,注册失败。");
        }
        return(flag);
    }
Ejemplo n.º 23
0
        /// <summary>
        /// 退出系统
        /// </summary>
        /// <returns></returns>
        public ActionResult exitsystem()
        {
            MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;

            if (logmember != null)
            {
                Session.Remove(AppContent.SESSION_WEB_LOGIN);
            }
            return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
        }
Ejemplo n.º 24
0
 public ActionResult AddMember(MemberInfoModel member)
 {
     if (member != null)
     {
         member.MStatus = 1;
         member.LogPwd  = DESEncrypt.Encrypt("666666", AppContent.SecrectStr);//加密密码
         string row = bll.AddMemberInfo(member);
     }
     return(RedirectToActionPermanent("Index", "MemberOpera", new { area = "AdminArea" }));
 }
Ejemplo n.º 25
0
    public void GetDetial(string Number)
    {
        MemberInfoModel member = MemInfoEditBLL.getMemberInfo(Number);

        this.Number.Text = member.Number.ToString();

        if (!BLL.CommonClass.CommonDataBLL.GetRole2(Session["Company"].ToString(), true))
        {
            this.Placement.Text = "";
        }
        else
        {
            this.Placement.Text = member.Placement.ToString();
        }
        if (!BLL.CommonClass.CommonDataBLL.GetRole2(Session["Company"].ToString(), false))
        {
            this.Recommended.Text = "";
        }
        else
        {
            this.Recommended.Text = member.Direct.ToString();
        }


        //this.Placement.Text = member.Placement.ToString();
        //this.Recommended.Text = member.Direct.ToString();
        this.Name.Text     = Encryption.Encryption.GetDecipherName(member.Name.ToString());
        this.PetName.Text  = member.PetName.ToString();
        this.Birthday.Text = member.Birthday.ToString("yyyy-MM-dd");
        if (Convert.ToInt32(member.Sex) == 0)
        {
            this.Sex.Text = GetTran("000095", "女");
        }
        else
        {
            this.Sex.Text = GetTran("000094", "男");
        }
        this.PostolCode.Text = member.PostalCode.ToString();
        this.HomeTele.Text   = Encryption.Encryption.GetDecipherTele(member.HomeTele.ToString());
        this.OfficeTele.Text = Encryption.Encryption.GetDecipherTele(member.OfficeTele.ToString());
        this.FaxTele.Text    = Encryption.Encryption.GetDecipherTele(member.FaxTele.ToString());
        labEmail.Text        = member.Email.ToString();
        this.MoblieTele.Text = member.MobileTele.ToString();
        //this.Country.Text = member.Country.ToString() + member.Province.ToString() + member.City.ToString() + member.Address.ToString();
        this.Country.Text     = member.City.Country + member.City.Province + member.City.City + member.City.Xian + Encryption.Encryption.GetDecipherAddress(member.Address);
        this.PaperNumber.Text = Encryption.Encryption.GetDecipherNumber(member.PaperNumber.ToString());
        this.PaperType.Text   = member.PaperType.PaperType.ToString();
        this.Bank.Text        = member.Bank.BankName.ToString() + member.Bankbranchname.ToString();
//        this.BankAddress.Text = member.BankCountry.ToString() + member.BankProvince.ToString()+member.BankCity.ToString()+member.BankAddress.ToString();
        this.BankAddress.Text = member.BankCity.Country + member.BankCity.Province + member.BankCity.City + Encryption.Encryption.GetDecipherAddress(member.BankAddress.ToString());
        this.BankNum.Text     = Encryption.Encryption.GetDecipherCard(member.BankCard.ToString());
        this.BankBook.Text    = Encryption.Encryption.GetDecipherName(member.BankBook.ToString());
        this.ExpectNum.Text   = member.ExpectNum.ToString();
        this.Remark.Text      = member.Remark.ToString();
    }
Ejemplo n.º 26
0
 private void AddXHMember()
 {
     if (checkUsername(this.txtMemberName.Text.Trim()) == "1")
     {
         Response.Write("<script>alert('该协会会员已存在!');</script>");
     }
     else
     {
         try
         {
             MemberInfoModel model = new MemberInfoModel();
             model.memberName  = KillSqlIn.Form_ReplaceByString(this.txtMemberName.Text, 20);
             model.password    = KillSqlIn.Form_ReplaceByString(this.txtPwd.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密
             model.memberLevel = "0";
             model.memberType  = type;
             //  model.memberCompanyType = this.ddlMemberType.SelectedValue;
             model.memberCompanyType = GetHyType();
             model.areaName          = "";
             model.memberCompanyName = txtXHName.Text;
             model.memberCompanyCode = "";
             model.memberTrueName    = txtTrueName.Text;
             model.sex                  = "";
             model.tel                  = txtTel.Text;
             model.fax                  = "";
             model.mobile               = "";
             model.address              = this.txtAddress.Text;
             model.post                 = "";
             model.email                = "";
             model.regTime              = System.DateTime.Now;
             model.shFlag               = 1;
             model.shTime               = DateTime.Now;
             model.shPerson             = " ";
             model.unPassReason         = "";
             model.memberStatus         = "ZC";//正常:ZC  禁用:JY
             model.buyMoneyAccount      = 0;
             model.buyMoneyAccountUsed  = 0;
             model.freeMoenyAccount     = 0;
             model.freeMoenyAccountUsed = 0;
             int i = new MemberInfoBLL().Add(model);
             if (i > 0)
             {
                 Response.Write("<script>alert('添加成功!');layer_close();</script>");
             }
             else
             {
                 Response.Write("<script>alert('添加失败!');</script>");
             }
         }
         catch (Exception ee)
         {
             Response.Write("<script>alert('出错了, 原因:'" + ee.Message + "'');</script>");
         }
     }
 }
Ejemplo n.º 27
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //AjaxPro.Utility.RegisterTypeForAjax(typeof(AddXHMember));
        type = Request.QueryString["type"] == null ? "" : Request.QueryString["type"].ToString();
        id   = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"].ToString());
        rd   = Request.QueryString["rd"] == null ? 0 : Convert.ToInt32(Request.QueryString["rd"].ToString());
        if (!IsPostBack)
        {
            loadMemberType();
            if (rd == 1)
            {
                this.btnSubmit.Visible = false;
                this.Button2.Visible   = false;
            }
            if (type == "XH")
            {
                this.panel_xh.Visible = true;
                if (id != 0)
                {
                    MemberInfoBLL   mBll   = new MemberInfoBLL();
                    MemberInfoModel mModel = mBll.GetModel(id);
                    this.txtAddress.Text    = mModel.address;
                    this.txtXHName.Text     = mModel.memberCompanyName;
                    this.txtMemberName.Text = mModel.memberName;
                    // this.ddlMemberType.SelectedValue = mModel.memberCompanyType;
                    SelectType(mModel.memberCompanyType);
                    this.txtPwd.Text      = mModel.password;
                    this.txtTel.Text      = mModel.tel;
                    this.txtTrueName.Text = mModel.memberTrueName;

                    this.txtMemberName.ReadOnly = true;
                }
            }
            else if (type == "HZSIS")
            {
                this.panel_xz.Visible = true;
                if (id != 0)
                {
                    MemberInfoBLL   mBll   = new MemberInfoBLL();
                    MemberInfoModel mModel = mBll.GetModel(id);

                    this.txtXZMember.Text   = mModel.memberName;
                    this.txtXZName.Text     = mModel.memberCompanyName;
                    this.txtXZPwd.Text      = mModel.password;
                    this.txtXZTel.Text      = mModel.tel;
                    this.txtXZTrueName.Text = mModel.memberTrueName;
                    this.txtXZType.Text     = mModel.memberCompanyType;

                    this.txtXZMember.ReadOnly = true;
                }
            }
        }
    }
Ejemplo n.º 28
0
        public ActionResult updatepwd(string pwd)
        {
            if (string.IsNullOrWhiteSpace(pwd))
            {
                return(Json("0"));
            }
            MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;
            string          newpwd    = DESEncrypt.Encrypt(pwd, AppContent.SecrectStr);
            int             row       = bll.UpdateUserPwd(logmember.ID, newpwd);

            return(Json(row));
        }
Ejemplo n.º 29
0
        public ActionResult Index(string bl = "")
        {
            string name = SysAdminConfigBLL.GetConfigValue(23);

            if (name == "NewTemplateArea")
            {
                return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
            }
            MemberInfoModel model = new MemberInfoModel();

            ViewBag.PageTitle = web.WebName;
            return(View(model));
        }
Ejemplo n.º 30
0
    /// <summary>
    ///  修改时绑定信息
    /// </summary>
    private void EditBind()
    {
        //this.rdPayType.Enabled = false;
        //this.dzpanel.Visible = false;

        string OrderId = GetOrderId();

        //绑定产品树
        ProductTree myTree = new ProductTree();

        myTree.Orderid      = OrderId;
        this.menuLabel.Text = myTree.getEditMenu10(GetStoreId(), GetOrderId());

        //绑定产品信息
        UptTree(OrderId);

        //绑定会员信息
        MemberInfoModel mi = MemberInfoModifyBll.getMemberInfo(GetMember());

        lblNumber.Text = mi.Number;
        lblName.Text   = Encryption.Encryption.GetDecipherName(mi.Name);
        //绑定订单信息
        MemberOrderModel mo = MemberOrderAgainBLL.GetMemberOrderByOrderId(OrderId);

        this.Txtxm.Text   = Encryption.Encryption.GetDecipherName(mo.Consignee);
        this.Txtyb.Text   = mo.ConZipCode;
        this.Email.Text   = mo.ConPost;
        this.Txtjtdh.Text = Encryption.Encryption.GetDecipherTele(mo.ConTelPhone);
        this.Txtyddh.Text = Encryption.Encryption.GetDecipherTele(mo.ConMobilPhone);
        this.CountryCity1.SelectCountry(mo.ConCity.Country, mo.ConCity.Province, mo.ConCity.City, mo.ConCity.Xian);
        this.Txtdz.Text         = Encryption.Encryption.GetDecipherAddress(mo.ConAddress);
        this.ddth.SelectedValue = mo.SendType.ToString();
        //this.rdPayType.SelectedValue = mo.DefrayType.ToString();
        this.Txtbz.Text = mo.Remark;
        //if (mo.DefrayState.ToString() == "1")
        //{
        //    this.rdPayType.Enabled = false;
        //}
        //if (this.rdPayType.SelectedValue == "2")
        //{
        //    this.dzpanel.Visible = true;
        //    this.lblNumber.Text = mo.ElectronicaccountId;
        //}
        this.DropCurrency.SelectedValue = mo.PayCurrency.ToString();
        DDLSendType.SelectedValue       = mo.SendWay.ToString();

        GetBindAddress();
        string addess = mo.ConCity.Country + " " + mo.ConCity.Province + " " + mo.ConCity.City + " " + mo.ConCity.Xian + " " + mo.ConAddress;

        this.rbtAddress.SelectedValue = addess;
    }