public User_Permission() { adt = new DBTableAdapters.User_PermisionTableAdapter(); dt = new DB.User_PermisionDataTable(); adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString; }
private void btLogin_Click(object sender, EventArgs e) { try { String connection = "Data Source=42.112.28.93;Initial Catalog=QT_2;Persist Security Info=True;User ID=wss_price;Password=HzlRt4$$axzG-*UlpuL2gYDu;connection timeout=200"; //String connectionCrawler = "Data Source=192.168.100.183;Initial Catalog=QTCrawler;Integrated Security=False;User=sa;Password=123"; //String connectionCrawler = @"Data Source=192.168.100.183;Initial Catalog=SaleNews;Integrated Security=False;User=sa;Password=123"; String connectionCrawler = "Data Source=172.22.30.82,1452;Initial Catalog=QTCrawler;Persist Security Info=True;User ID=qt_vn;Password=@F4sJ=l9/ryJt9MT;connection timeout=200"; String logConnection = "Data Source=172.22.30.86,1455;Initial Catalog=QT_2;Persist Security Info=True;User ID=qt_vn;Password=@F4sJ=l9/ryJt9MT;connection timeout=200"; switch (QT.Entities.Server.ServerRun) { case "store": connection = connection.Replace("42.112.28.93", "."); break; case "hvtcphc": logConnection = logConnection.Replace("118.70.205.94", "172.16.34.86"); connectionCrawler = connectionCrawler.Replace("118.70.205.94", "."); break; case "hvtcdn": logConnection = logConnection.Replace("118.70.205.94", "10.168.200.86"); connectionCrawler = connectionCrawler.Replace("118.70.205.94", "10.168.200.82"); break; case "fpt": connection = connection.Replace("42.112.28.93", "172.22.1.82"); break; } QT.Entities.Server.ConnectionString = connection; QT.Entities.Server.ConnectionStringCrawler = connectionCrawler; QT.Entities.Server.LogConnectionString = logConnection; adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString; //adt.FillBy_UserPass(dt, txtUser.Text.Trim(), Common.GetPassWord(txtPass.Text.Trim())); adt.FillBy_UserPass(dt, txtUser.Text.Trim(), Bussiness.CryptoWSS.Encrypt(txtPass.Text.Trim())); if (dt.Rows.Count > 0) { DialogResult = DialogResult.OK; QT.Users.User.UserName = txtUser.Text.Trim(); QT.Users.User.UserID = Common.Obj2Int(dt.Rows[0]["ID"].ToString()); //Check Quyền DBTableAdapters.User_PermisionTableAdapter userpermisionAdapter = new DBTableAdapters.User_PermisionTableAdapter(); userpermisionAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString; DB.User_PermisionDataTable userpermissionTable = new DB.User_PermisionDataTable(); userpermisionAdapter.FillBy_IDUser(userpermissionTable, QT.Users.User.UserID); if (userpermissionTable.Rows.Count > 0) { List <int> listper = new List <int>(); for (int i = 0; i < userpermissionTable.Rows.Count; i++) { listper.Add(Common.Obj2Int(userpermissionTable.Rows[i]["IDPermission"].ToString())); } QT.Users.User.PermisionID = listper; } QT.Entities.Server.UserID = QT.Users.User.UserID; //Log đăng nhập LogJobAdapter.SaveLog(JobName.Login, "Đăng nhập Manager", 0, (int)JobTypeData.KhongXacDinh); this.Close(); } else { MessageBox.Show("User hoặc mật khẩu không dúng, liên hệ với admin"); this.txtUser.Focus(); this.txtUser.SelectAll(); } } catch (Exception) { MessageBox.Show("Không kết nối được, bạn hãy thử kiểm tra lại mạng"); } }