Exemplo n.º 1
0
 public HotelForm(Manager user)
 {
     InitializeComponent();
     this.user = user;
     //读取卡
     new ReadCardUtil().ReadCustomer(readRun, this);
     RegitUser(new object(), new EventArgs());
 }
Exemplo n.º 2
0
        public static Manager getManager(string account)
        {

            SqlConnection conn = util.DBConnection.getConnection();
            try
            {
                conn.Open();
            }
            catch (Exception e)
            {
                if (MessageBox.Show("数据库连接失败,请检查数据库配置或者网络配置", "数据库连接失败", MessageBoxButtons.OK) == System.Windows.Forms.DialogResult.OK)
                {
                    Application.Exit();
                }
            }
            Manager user = null;
            try
            {
                Console.WriteLine("初始化查询参数");
                string sql = "SELECT [id],[password],[day],[type] FROM sys_manager WHERE account=@account";
                Console.WriteLine("连接开启");
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddWithValue("@account", account);

                    using (SqlDataReader dr = cmd.ExecuteReader())
                    {
                        Console.WriteLine("结果:" + dr.HasRows);
                        if (dr.Read())
                        {
                            int id = Convert.ToInt32(dr["id"]);
                            string password = Convert.ToString(dr["password"]);
                            int day = Convert.ToInt32(dr["day"]);
                            int type = Convert.ToInt32(dr["type"]);
                            user = new Manager();
                            user.Id = id;
                            user.Account = account;
                            user.Passwd = password;
                            user.Day = day;
                            user.Type = type;
                        }
                        dr.Close();
                    }
                }
                Console.WriteLine(user);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message + "\r\n" + ex.StackTrace);
            }
            finally
            {
                DBConnection.closeConnection(conn);
            }
            return user;
        }
Exemplo n.º 3
0
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);

            //auto hotel
            model.Manager user = new model.Manager();
            user.Account = "trainning";
            user.Passwd = "trainning";
            user.Day = 3;
            user.Id = 1;
            user.Type = 2;
            Application.Run(new view.TrainForm());
        }
Exemplo n.º 4
0
 public SearchForm(Manager user)
 {
     this.user = user;
     InitializeComponent();
 }
Exemplo n.º 5
0
 public TrainForm(Manager user)
 {
     this.user = user;
 }