public void DangNhap()
{
string TenDangNhap = txtTenDangNhap.Text.ToUpper();
string MatKhau = DAO_Setting.GetSHA1HashData(txtMatKhau.Text.ToString());
bool KT = BUS_DangNhap.KiemTraDangNhap(TenDangNhap, MatKhau);
if (KT == true)
{
DataTable db = DAO_DangNhap.QuanLy(TenDangNhap, MatKhau);
if (db.Rows.Count > 0)
{
DataRow dr = db.Rows[0];
QuanLy = new DTO_QuanLy();
QuanLy.Id = Int32.Parse(dr["ID"].ToString());
QuanLy.Tendangnhap = dr["TenDangNhap"].ToString();
QuanLy.Idchinhanh = dr["IDChiNhanh"].ToString();
QuanLy.Manhanvien = dr["MaNhanVien"].ToString();
QuanLy.Tennguoidung = dr["TenNguoiDung"].ToString();
QuanLy.Sdt = dr["SDT"].ToString();
QuanLy.IDNhomNguoiDung = Int32.Parse(dr["IDNhomNguoiDung"].ToString());
//DAO_Setting.ThemLichSuQuanLy(frmKiemTraThemMayIn.QuanLy.Id, frmKiemTraThemMayIn.QuanLy.IDNhomNguoiDung, frmKiemTraThemMayIn.QuanLy.Idchinhanh, "Đăng Nhập", "Cài đặt máy in");
frmCaiDatThongTin fr = new frmCaiDatThongTin();
txtMatKhau.Text = "";
txtMatKhau.Select();
this.Hide();
fr.ShowDialog();
this.Show();
}
else
{
MessageBox.Show("Đăng nhập không thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Tên đăng nhập không tồn tại.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoaiDoUong_TrangThai(DTO_QuanLy dl)
{
xl.table_Command("Update LoaiDoUong set TrangThai=N'" + dl.TrangThai + "' where MaLoai = '" + dl.MaLoai + "'");
}
public void LoaiDoUong_INSERT(DTO_QuanLy dl)
{
xl.table_Command("INSERT into LoaiDoUong VALUES( N'" + dl.TenLoai + "','')");/*'" + dl.MaLoai + "',*/
}
public DataTable LoaiDoUong_Search(DTO_QuanLy dl)
{
return(xl.table_Select("Select * from LoaiDoUong where TenLoai like N'" + dl.TuKhoa + "%' "));
}
public void TenDoUong_TrangThai(DTO_QuanLy dl)
{
xl.table_Command("Update TenDoUong set TrangThai=N'" + dl.TrangThai + "' where STT = '" + dl.STT + "'");
}
public void TenDoUong_Update(DTO_QuanLy dl)
{
xl.table_Command("Update TenDoUong set MaLoai ='" + dl.MaLoai + "', TenDoUong= N'" + dl.TenDoUong + "',DonGia= '" + dl.DonGia + "' where STT = '" + dl.STT + "'");
}
public void TenDoUong_INSERT(DTO_QuanLy dl)
{
xl.table_Command("INSERT into TenDoUong VALUES('" + dl.MaLoai + "', N'" + dl.TenDoUong + "', '" + dl.DonGia + "','')");
}
public DataTable ChonTen_Select(DTO_QuanLy dl)
{
return(xl.table_Select("select * from TenDoUong where MaLoai='" + dl.MaLoai + "'"));
}
public DataTable Loai_Select(DTO_QuanLy dl)
{
return(xl.table_Select("select * from LoaiDoUong where TrangThai=N''"));
}
public DataTable ChonLoai_Select(DTO_QuanLy dl)
{
return(xl.table_Select("select * from LoaiDoUong"));
}
