icard.aspx.cs

最好用的站点内容管理系统 全部源代码都有

        lockActions(ids, 7);
    }

    /// <summary>
    /// lockActions 的摘要说明
    /// 锁定/解锁动作函数
    /// intlock 0为取消锁定，1为锁定，2为设置为过期，3为设置为不过期，4为设置为已使用，5设置为未使用
    /// </summary>
    protected void lockActions(string cId, int intlock)
    {
        this.Authority_Code = "U027";
        this.CheckAdminAuthority();
        if (cId != null && cId != "")
        {
            string lockstr = "";
            switch (intlock)
            {
                case (0):
                    lockstr = " set islock=0";
                    break;
                case (1):
                    lockstr = " set islock=1";
                    break;
                case (2):
                    lockstr = "000000000";
                    break;
                case (4):
                    lockstr = " set isuse=1";
                    break;
                case (5):
                    lockstr = " set isuse=0";
                    break;
                case (6):
                    lockstr = " set isbuy=1";
                    break;
                case (7):
                    lockstr = " set isbuy=0";
                    break;
                default:
                    break;
            }

            rd.update_userInfo(cId, lockstr,1);
            PageRight("更新点卡成功。", "icard.aspx");
        }
        else
        {
            PageError("请选择至少一个点卡<br />", "icard.aspx");
        }
    }


    /// <summary>
    /// PageNavigator1_PageChange 的摘要说明
    /// 分页加载函数
    /// </summary>
    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        string islock = Request.QueryString["islock"];
        string isuse = Request.QueryString["isuse"];
        string isbuy = Request.QueryString["isbuy"];
        string timeout = Request.QueryString["timeout"];
        string ReqSite = Request.QueryString["SiteID"];
        string _islock = "";
        string _isuse = "";
        string _isbuy = "";
        string _timeout = "";
        string _SiteID = "";
        if (islock != "" && islock != null) { _islock = islock.ToString(); }
        if (isuse != "" && isuse != null) { _isuse = isuse.ToString(); }
        if (isbuy != "" && isbuy != null) { _isbuy = isbuy.ToString(); }
        if (timeout != "" && timeout != null) { _timeout = timeout.ToString(); }
        if (ReqSite != "" && ReqSite != null) { _SiteID = SiteID.ToString(); }
        StartLoad(PageIndex, _islock, _isuse, _isbuy, _timeout, _SiteID, "", "");
    }

    /// <summary>
    /// PageNavigator1_PageChange 的摘要说明
    /// 分页加载列表函数
    /// </summary>
    protected void StartLoad(int PageIndex, string _islock, string _isuse, string _isbuy, string _timeout, string _SiteID, string cardnumber, string cardpassword)
    {
        int i, j;
        DataTable dt = rd.GetPage(_islock, _isuse, _isbuy, _timeout, _SiteID, cardnumber, cardpassword, PageIndex, 20, out i, out j, null);
        this.PageNavigator1.PageCount = j;
        this.PageNavigator1.PageIndex = PageIndex;
        this.PageNavigator1.RecordCount = i;
        if (dt != null)
        {
            if (dt.Rows.Count > 0)
            {
                //----------------------------------------添加列------------------------------------------------
                dt.Columns.Add("op", typeof(string));
                dt.Columns.Add("islockStr", typeof(string));
                dt.Columns.Add("isBuyStr", typeof(string));
                dt.Columns.Add("isUseStr", typeof(string));
                dt.Columns.Add("isTimeOut", typeof(string));
                dt.Columns.Add("CardPassWords", typeof(string));
                dt.Columns.Add("UserNums", typeof(string));
                //----------------------------------------添加列结束--------------------------------------------
                for (int k = 0; dt.Rows.Count > k; k++)
                {
                    if (dt.Rows[k]["UserNum"].ToString().Trim() != "")
                    {
                        NetCMS.Content.Common.rootPublic pd = new NetCMS.Content.Common.rootPublic();
                        dt.Rows[k]["UserNums"] = "<a href=\"../../" + NetCMS.Config.UIConfig.dirUser + "/showuser-" + pd.getUserName(dt.Rows[k]["UserNum"].ToString()) + ".aspx\" target=\"_blank\" class=\"list_link\" title=\"此点卡已经被" + pd.getUserName(dt.Rows[k]["UserNum"].ToString()) + "使用或者购买\"><font color=\"red\">[*]</font></a>";
                    }
                    dt.Rows[k]["op"] = "<a href=\"iCardEdit.aspx?Id=" + dt.Rows[k]["id"] + "\" class='list_link'><img src=\"../../sysimages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/edit.gif\" border=\"0\" alt='修改'></a><a href=\"iCard.aspx?Type=Del&id=" + dt.Rows[k]["id"] + "\" class='list_link'><img src=\"../../sysimages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/del.gif\" border=\"0\" alt='删除' onClick=\"{if(confirm('确定要删除吗？')){return true;}return false;}\"></a><input type=\"checkbox\" name=\"cid\" value=\"" + dt.Rows[k]["id"] + "\" />";
                    string Pstr = dt.Rows[k]["CardPassWord"].ToString();
                    dt.Rows[k]["CardPassWords"] = NTSecurity.FDESEncrypt(Pstr, 0);
                    if (dt.Rows[k]["islock"].ToString() == "1")
                    {
                        dt.Rows[k]["islockStr"] = "<img src=\"../../sysImages/folder/no.gif\" alt=\"已锁定\" border=\"0\" />";
                    }
                    else
                    {
                        dt.Rows[k]["islockStr"] = "<img src=\"../../sysImages/folder/yes.gif\" alt=\"正常\" border=\"0\" /></span>";
                    }
                    if (dt.Rows[k]["isBuy"].ToString() == "1")
                    {
                        dt.Rows[k]["isBuyStr"] = "<img src=\"../../sysImages/folder/yes.gif\" border=\"0\" /></span>";
                    }
                    else
                    {
                        dt.Rows[k]["isBuyStr"] = "<img src=\"../../sysImages/folder/no.gif\" border=\"0\" />";
                    }
                    if (dt.Rows[k]["isUse"].ToString() == "1")
                    {
                        dt.Rows[k]["isUseStr"] = "<img alt=\"使用者：" + dt.Rows[k]["UserNum"].ToString() + "\" src=\"../../sysImages/folder/yes.gif\" border=\"0\" /></span>";
                    }
                    else
                    {
                        dt.Rows[k]["isUseStr"] = "<img src=\"../../sysImages/folder/no.gif\" border=\"0\" />";
                    }

                    if (dt.Rows[k]["TimeOutDate"].ToString().Split('-')[0] != "2099")
                    {
                        DateTime dtime = DateTime.Parse(dt.Rows[k]["TimeOutDate"].ToString());
                        DateTime dnTime = System.DateTime.Now;
                        if (DateTime.Parse(dt.Rows[k]["TimeOutDate"].ToString()) >= System.DateTime.Now)
                        {
                            TimeSpan days = dtime - dnTime;
                            int daysTF = days.Days;
                            string daysTFchar = "";
                            if (daysTF > 0)
                            {
                                daysTFchar = daysTF + "天" + days.Hours + "小时";
                            }
                            else
                            {
                                daysTFchar = days.Hours + "小时";
                            }
                            dt.Rows[k]["isTimeOut"] = "未过期[" + daysTFchar + "]";
                        }
                        else
                        {
                            dt.Rows[k]["isTimeOut"] = "<span class=\"tbie\">已过期</span>";
                        }
                    }
                    else
                    {
                        dt.Rows[k]["isTimeOut"] = "永不过期";
                    }
                }
            }
        }
        cardlists.DataSource = dt;                              //设置datalist数据源
        cardlists.DataBind();                                   //绑定数据源
    }


    protected void DataList1_ItemCommand(object sender, EventArgs e)
    {

    }
    /// <summary>
    /// search_button_Click 的摘要说明
    /// 获取搜索
    /// </summary>
    protected void search_button_Click(object sender, EventArgs e)
    {
        #region 获得表单搜索
        string cardnumber = "";
        string cardpassword = "";
        string islock = Request.QueryString["islock"];
        string isuse = Request.QueryString["isuse"];
        string isbuy = Request.QueryString["isbuy"];
        string timeout = Request.QueryString["timeout"];
        string SiteID = Request.QueryString["SiteID"];
        string _islock = "";
        string _isuse = "";
        string _isbuy = "";
        string _timeout = "";
        string _SiteID = "";
        if (islock != "" && islock != null) { _islock = islock.ToString(); }
        if (isuse != "" && isuse != null) { _isuse = isuse.ToString(); }
        if (isbuy != "" && isbuy != null) { _isbuy = isbuy.ToString(); }
        if (timeout != "" && timeout != null) { _timeout = timeout.ToString(); }
        if (SiteID != "" && SiteID != null) { _SiteID = SiteID.ToString(); }
        if (Request.Form["cardnumber"] != "" && Request.Form["cardnumber"] != null)
        {
            cardnumber = Request.Form["cardnumber"];
        }
        if (Request.Form["cardpassword"] != "" && Request.Form["cardpassword"] != null)
        {
            cardpassword = NTSecurity.FDESEncrypt(Request.Form["cardpassword"], 1);
        }
        StartLoad(1, _islock, _isuse, _isbuy, _timeout, _SiteID, cardnumber, cardpassword);
        #endregion 获得表单搜索
    }
}