using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using System.Diagnostics;
using System.Collections;
using System.IO;
using Microsoft.Win32;
using System.Data;

namespace LYFZ.NationalMarketing
{
    public partial class Login : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        string strlogin = Admin.PublicClass.myDB.ToString();
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (this.txtname.Text == "")
            {
                Response.Write("<script>alert('请输入用户名！');</script>"); return;
            }
            if (this.txtpwd.Value == "")
            {
                Response.Write("<script>alert('请输入密码！');</script>"); return;
            }
            string qu = "select * from login";
            MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection(strlogin);
            MySqlCommand da = new MySql.Data.MySqlClient.MySqlCommand(qu, con);
            con.Open();
            MySqlDataReader date = da.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Columns.Add("id");
            dt.Columns.Add("Account");
            dt.Columns.Add("password");
            while (date.Read() == true)
            {
                DataRow row = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i] = date[i];
                } dt.Rows.Add(row);
            }
            
            string sdad = dt.Rows[0]["Account"].ToString();
            string sgre = dt.Rows[0]["password"].ToString();
            Session["Account"] = sdad;
            if (this.txtname.Text == sdad && this.txtpwd.Value == sgre)
            {
                Response.Redirect("admin/Management.aspx");
            }
            else
            {
                Response.Write("<script>alert('登录失败！密码错误或账号不存在！');</script>");
                this.txtname.Text = "";
                this.txtpwd.Value = "";
            }
        }
    }
}