using System;
using System.Windows.Forms;
using Oracle.DataAccess.Client;
using System.Configuration;
using System.Data;
using System.Drawing;
using 优软MES.DataOperate;
using 优软MES.Entity;

namespace 优软MES
{
    public partial class Login : Form
    {
         
        public static readonly string ConnectionStrings = ConfigurationSettings.AppSettings["DatabaseConnection"];
        OracleCommand command = null;
        OracleConnection connection = new OracleConnection(ConnectionStrings);

        public Login()
        {
            InitializeComponent();
            //让Label透明
            //label1.BackColor = Color.Transparent; 
            //label2.BackColor = Color.Transparent;
            //label3.BackColor = Color.Transparent;
        }
        //点击登陆按钮的时候
        private void LoginButton_Click(object sender, EventArgs e)
        {
            LoginCheck(UserName.Text, PassWord.Text);
        }

        //点击没有密码的时候给出的提示信息
        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            MessageBox.Show("请联系管理员开设账号");
        }

        /// <summary>
        ///  //检查账号和密码是否正确
        /// </summary>
        /// <param name="UserName">用户名</param>
        /// <param name="PassWord">密码</param>
        private void LoginCheck(string UserName,string PassWord) {

            DataTable dt = new DataTable();
            string SQL = "select em_code from employee where em_code=:UserName and em_password =:PassWord";
            command = connection.CreateCommand();
            command.CommandText = SQL;
            //将用户名和密码参数化
            command.Parameters.Add(new OracleParameter("UserName", OracleDbType.Varchar2, ParameterDirection.Input));
            command.Parameters.Add(new OracleParameter("PassWord", OracleDbType.Varchar2, ParameterDirection.Input));
            command.Parameters["UserName"].Value = UserName;
            command.Parameters["PassWord"].Value = PassWord;
            OracleDataAdapter ad = new OracleDataAdapter();
            ad.SelectCommand = command;
            ad.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                this.Hide();
                setUser();//设置User的全局变量
                Main dialog = new Main();
                dialog.ShowDialog();
                this.Close();
            }
            else {
                MessageBox.Show("用户名密码错误");
            }
        }

        //设置User类的全局变量，类似于Session
        public void setUser() {
            DataHelper dh = new DataHelper();
            DataTable dt = new DataTable();
            string[] field = { "*" };
            dt= dh.getFieldsDataByCondition("Employee",field,"em_code='"+UserName.Text+"'");
            User.UserCode = dt.Rows[0]["em_code"].ToString();
            User.UserDepartment = dt.Rows[0]["em_depart"].ToString();
            User.UserDepartmentCode = dt.Rows[0]["em_departmentcode"].ToString();
            User.UserName = dt.Rows[0]["em_name"].ToString();
            User.UserPosition = dt.Rows[0]["em_position"].ToString();
            User.UserProfessName = dt.Rows[0]["em_professname"].ToString();
        }
    }
}