memberinfo.aspx.cs

易想商城系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Collections.Generic;
using YXShop.Common;

namespace YXShop.Web.Admin.Consumer
{
    public partial class MemberInfo : System.Web.UI.Page
    {
        YXShop.BLL.MemberInfo dataCA = new YXShop.BLL.MemberInfo();
        public PageSet ps;
        private static int UserID = 0;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                if (YXShop.Common.WebUtility.isNumeric(Request.QueryString["Pro_ID"]))
                {
                    UserID = Convert.ToInt32(Request.QueryString["Pro_ID"]);
                    BindOrders(UserID);
                }
                grid();
                griddq();
                gridqx();
                string strsqlxx = "UserID" + "='" + UserID + "' " + "and NoteType = 0 and BuckleOrAdd = 0";
                Label50.Text = gyfs(strsqlxx).ToString();
                string strsqlxxc = "UserID" + "='" + UserID + "' " + "and NoteType = 0 and BuckleOrAdd = 1";
                Label51.Text = gyfs(strsqlxxc).ToString();
                Label52.Text = (Convert.ToDouble(Label50.Text.Trim()) - Convert.ToDouble(Label51.Text.Trim())).ToString();

                #region 填充数据
                YXShop.BLL.UserInAndExp datab = new YXShop.BLL.UserInAndExp();
                string strsql = "UserID" + "='" + UserID + "' " + "and incomeAndExpStatus = 0";
                List<YXShop.Model.UserInAndExp> datas = datab.GetList(strsql);
                float strcg = 0;
                foreach (YXShop.Model.UserInAndExp dd in datas)
                {
                    int i = datas.Count;
                    float cdm1 = Convert.ToInt32(dd.AdsumMoney.ToString());
                    float cdm2;
                    cdm2 = Convert.ToInt32(dd.AdsumMoney.ToString());
                    if (i == 0)
                    {
                        strcg = cdm1;
                    }
                    else
                    {
                        strcg = strcg + cdm1;
                    }
                }
                string strsqlz = "UserID" + "='" + UserID + "' " + "and incomeAndExpStatus = 1";
                List<YXShop.Model.UserInAndExp> datasz = datab.GetList(strsqlz);
                double strcgz = 0;
                foreach (YXShop.Model.UserInAndExp dd in datasz)
                {
                    int i = datasz.Count;
                    double cdm1 = Convert.ToDouble(dd.AdsumMoney.ToString());
                    double cdm2;
                    cdm2 = Convert.ToDouble(dd.AdsumMoney.ToString());
                    if (i == 0)
                    {
                        strcgz = cdm1;
                    }
                    else
                    {
                        strcgz = strcgz + cdm1;
                    }

                }
                Label47.Text = strcg.ToString();
                Label48.Text = strcgz.ToString();
                Label49.Text = (strcg - strcgz).ToString();
                DataTable dt = dataCA.GetId(UserID.ToString());
                //YXShop.BLL.UserCommon ucBll = new YXShop.BLL.UserCommon();
                //List<YXShop.Model.UserCommon> ucList = ucBll.GetListByColumn("UID", UserID);
                //if (dataCA.GetListByColumn("uUserId", UserID).Count != 0)
                if(dt.Rows.Count>0)
                {
                    Label1.Text =dt.Rows[0]["UserName"].ToString(); //data[0].uUserName;
                    string strzt;
                    if (dt.Rows[0]["UState"].ToString() == "2")
                    {
                        strzt = "冻结";
                    }
                    else if (dt.Rows[0]["UState"].ToString() == "1")
                    {
                        strzt = "正常";
                    }
                    else 
                    {
                        strzt = "正在审核";
                    }
                    Label2.Text = strzt;
                    Label3.Text =dt.Rows[0]["UEmail"].ToString();//data[0].uEMail;
                    YXShop.BLL.MemberRand dataCAz = new YXShop.BLL.MemberRand();
                    List<YXShop.Model.MemberRand> data1 = dataCAz.GetzId(Convert.ToInt32(dt.Rows[0]["uGroupId"].ToString()));
                    if (data1.Count > 0)
                    {
                        Label4.Text = data1[0].Rank_name;
                        Label5.Text = data1[0].Rank_name;
                        Label7.Text = dt.Rows[0]["fSurplusCapital"].ToString();
                        string dateDiff = "0";
                        if (Convert.ToDateTime(dt.Rows[0]["PeriodOfValidity"].ToString()) > System.DateTime.Now)
                        {

                            TimeSpan ts1 = new TimeSpan(Convert.ToDateTime(dt.Rows[0]["PeriodOfValidity"].ToString()).Ticks);
                            TimeSpan ts2 = new TimeSpan(DateTime.Now.Ticks);
                            TimeSpan ts = ts1.Subtract(ts2).Duration();
                            dateDiff = ts.Days.ToString();
                        }
                        Label8.Text = dt.Rows[0]["fUsableStamps"].ToString();
                        Label9.Text = dt.Rows[0]["fIntegral"].ToString();
                        Label10.Text = dateDiff;
                        Label11.Text = dataCAz.ts(UserID).ToString();
                        Label12.Text = dt.Rows[0]["fCostFund"].ToString();
                        Label13.Text = dt.Rows[0]["fSignInTimes"].ToString();
                        Label14.Text = dt.Rows[0]["fLastSignTime"].ToString();
                        Label15.Text = dt.Rows[0]["fLastSignIP"].ToString();
                        Label16.Text = dt.Rows[0]["fRegisterTime"].ToString();
                        Label17.Text = dt.Rows[0]["cTrueName"].ToString();
                        Label18.Text = dt.Rows[0]["cAddrInfo"].ToString();
                        Label19.Text = dt.Rows[0]["cPrefixal"].ToString();
                        Label20.Text = dt.Rows[0]["post"].ToString();
                        Label21.Text = dt.Rows[0]["cAddrInfo"].ToString();
                        Label22.Text = dt.Rows[0]["cHomePhone"].ToString();
                        Label23.Text = dt.Rows[0]["cOfficePhone"].ToString();
                        Label24.Text = dt.Rows[0]["cMobilePhone"].ToString();
                        Label25.Text = dt.Rows[0]["cFaxNumber"].ToString();
                        Label26.Text = dt.Rows[0]["UEmail"].ToString();//dt.Rows[0]["UState"].uEMail;
                        Label27.Text = dt.Rows[0]["cPersonIndex"].ToString();
                        Label28.Text = dt.Rows[0]["pBirthday"].ToString();
                        Label29.Text = dt.Rows[0]["pAH"].ToString();
                        string strxb = dt.Rows[0]["pSex"].ToString();
                        if (strxb == "0")
                        {
                            strxb = "女";
                        }
                        if (strxb == "1")
                        {
                            strxb = "男";
                        }
                        Label30.Text = strxb;
                        Label31.Text = dt.Rows[0]["pEB"].ToString();
                        Label32.Text = dt.Rows[0]["pLaH"].ToString();
                        Label33.Text = dt.Rows[0]["pEaL"].ToString();
                        Label34.Text = dt.Rows[0]["pAaH"].ToString();
                        Label35.Text = dt.Rows[0]["pPapersNumber"].ToString();
                        Label36.Text = dt.Rows[0]["pNation"].ToString();
                        Label37.Text = dt.Rows[0]["pMarriage"].ToString();
                        Label38.Text = dt.Rows[0]["pNos"].ToString();
                        Label39.Text = dt.Rows[0]["pCaH"].ToString();
                        Label40.Text = dt.Rows[0]["pPaH"].ToString();
                        Label41.Text = dt.Rows[0]["pMonthlyIncome"].ToString();
                        Label42.Text = dt.Rows[0]["dIncName"].ToString();
                        Label43.Text = dt.Rows[0]["dPosition"].ToString();
                        Label44.Text = dt.Rows[0]["dDepartment"].ToString();
                        Label45.Text = dt.Rows[0]["dOperation"].ToString();
                        Label46.Text = dt.Rows[0]["dIncAddr"].ToString();
                    }

                }
                #endregion

            }
            if ((!IsPostBack) || (string.IsNullOrEmpty(Request["Event"])))
            {
                BindOrders(UserID);
                grid();
                griddq();
                gridqx();
            }
        }
        #region 跳转
        protected void Button16_Click(object sender, EventArgs e)
        {
            YXShop.Model.MemberInfo data = new YXShop.Model.MemberInfo();
            dataCA.Amend(UserID, "fMemberState", 0);
            HttpContext.Current.Response.Redirect("good.aspx");
        }

        protected void Button17_Click(object sender, EventArgs e)
        {
           
                dataCA.Delete(Convert.ToInt32(UserID));
           
            
            HttpContext.Current.Response.Redirect("good.aspx");
        }

        protected void Button18_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("../Accessories/Sendout.aspx?hyname=" + Label1.Text);
        }

        //protected void Button19_Click(object sender, EventArgs e)
        //{
        //    Response.Redirect("Cashaward.aspx?hydhid=" + UserID.ToString());
        //}
        protected void Button19_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("PayoutMoney.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button20_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("PraisePointjs.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button21_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("AddTermdg.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button22_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("AddTermjs.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button23_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("PraisePointdg.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button24_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("EmailManagedg.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button25_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("Exchangevalidity.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button26_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("Exchangecoupon.aspx?hydhid=" + UserID.ToString());
        }

        protected void Button27_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("ExchangeIncome.aspx?hydhid=" + UserID.ToString());
        }
        protected void Button30_Click(object sender, EventArgs e)
        {
            HttpContext.Current.Response.Redirect("ExchangeBank.aspx?hydhid=" + UserID.ToString());

        }
        #endregion


        protected string Users(int GroupId)
        {
            string str = "";
            YXShop.BLL.UserInAndExp datab = new YXShop.BLL.UserInAndExp();
            if (datab.GetModel(GroupId).RemitJoinMode.ToString() == "1")
            {
                str = "银行汇款";
            }
            if (datab.GetModel(GroupId).RemitJoinMode.ToString() == "2")
            {
                str = "虚拟货币";
            }
            if (datab.GetModel(GroupId).RemitJoinMode.ToString() == "3")
            {
                str = "现金支付";
            }
            return str;
        }
        #region 订单列表
        #region Bind Data
        private void BindOrders(int UserId)
        {
            int pageIndex = Request["pageIndex"] == null ? 0 : int.Parse(Request["pageIndex"]);
            if (pageIndex < 0)
            {
                pageIndex = 0;
            }
            if ((Request["Event"] == null) || (Request["Event"] == ""))
            {
                pageIndex = 0;
            }
            YXShop.BLL.Orders databo = new YXShop.BLL.Orders();
            List<YXShop.Model.Orders> datas = databo.GetListByColumn("UserId", UserId);
            GridView1.DataSource = datas;
            int RecordCount = 0;
            if (datas != null)
                RecordCount = datas.Count;
            ps = new PageSet(RecordCount, PageSet.PageSize, pageIndex);
            if (ps.PageCount <= pageIndex + 1)
            {
                pageIndex = ps.PageCount - 1;
            }

            GridView1.PageSize = PageSet.PageSize;
            GridView1.PageIndex = pageIndex;
            if (RecordCount < 1)
            {
                GridView1.BackColor = System.Drawing.Color.White;
            }
            else
            {
                GridView1.BackColor = System.Drawing.Color.FromArgb(0x5D, 0x8F, 0xB2);
            }
            GridView1.DataBind();
        }

        protected void dgTBOrderInfo_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (!(e.Row.DataItem is YXShop.Model.Orders))
            {
                return;
            }
            YXShop.Model.Orders data = (e.Row.DataItem as YXShop.Model.Orders);
            if (data != null)
            {
                e.Row.Cells[1].Text = "<a href=\"../Consumer/MemberInfo.aspx?Pro_ID=" + data.UserId + "\">" + this.UserReal(Convert.ToInt32(data.UserId)) + "</a>";
                e.Row.Cells[2].Text = "<a href=\"../Consumer/MemberInfo.aspx?Pro_ID=" + data.UserId + "\">" + this.UserName(Convert.ToInt32(data.UserId)) + "</a>";
                e.Row.Cells[3].Text = this.UserReal(Convert.ToInt32(data.UserId));
                e.Row.Cells[5].Text = this.checkInv(data.OrderId);
                e.Row.Cells[6].Text = this.checkInvoice(data.OrderId);
            }
        }
        #endregion

        #region 客户信息查询
        protected string UserName(int UserID)
        {
            string str = "";
            YXShop.BLL.UserCommon ucBll = new YXShop.BLL.UserCommon();
            List<YXShop.Model.UserCommon> ucList = ucBll.GetListByColumn("UID", UserID);
            if (ucList.Count > 0)
            {