using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using web;


public partial class adminmso888_cpprivateLine : System.Web.UI.Page
{
    private static DataSet ds;
    private static DataSet mapds;
    protected static int rcount;
    private static string sql;
    protected void Page_Load(object sender, EventArgs e)
    {
        // 未登陆就进行一次检测
        if (this.Session["admin_id"] == null)
        {
            HttpContext.Current.Response.Redirect("admincp.aspx");
        }
    }

    protected void btnPrlinSearch_Click(object sender, EventArgs e)
    {
        system system = new system();
        string str = system.ChkSql(this.tbsuserid.Text.ToString().Trim());
        sql = "select * from mhcmember..tbl_privateLine with(nolock) where privateUser='"+ str + "'";

        ds = new DataProviders().ExecuteSqlDs(sql, "DataGrid1");
        this.DataGrid1.DataSource = ds;
        this.DataGrid1.CurrentPageIndex = 0;
        this.DataGrid1.DataBind();
        rcount = ds.Tables[0].Rows.Count;
    }

    protected void btnaddPrlin_Click(object sender, EventArgs e)
    {
        system system = new system();
        string str = system.ChkSql(this.tbuserid.Text.ToString().Trim());
        int nPrivateLine = int.Parse(this.PrivateLinType.SelectedItem.Value);

        DataProviders providers = new DataProviders();
        SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..tbl_privateLine with(nolock) where privateUser='" + str+ "' and privateToLine=" + nPrivateLine);

        if(reader.HasRows)
        {
            base.Response.Write("<script language=javascript>alert('已存在該私有線路，無法重複添加噢')</script>");

            reader.Close();
            providers.CloseConn();
            return;
        }

        reader.Close();
        providers.CloseConn();

        // 插入一个记录信息
        string mySql = string.Concat(new object[] {
            "INSERT INTO [MHCMember].[dbo].[tbl_privateLine] ([privateUser], [privateIsVaild], [privateContext], [privateToLine]) OUTPUT INSERTED.[pidx], INSERTED.[privateUser], INSERTED.[privateIsVaild], INSERTED.[privateContext], INSERTED.[privateAddTime], INSERTED.[privateToLine] VALUES ('",
            str,"','1','通過網站添加[from web]','",nPrivateLine,"')"
             });
        new DataProviders().ExecuteSql(mySql);
    }

    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
        this.DataGrid1.DataSource = ds;
        this.DataGrid1.DataBind();
    }
}