public bool CheckNV(PhanQuyenObj pqObj) // kiểm tra mk tk khi đăng nhập là nhân viên
{
DataTable dt = new DataTable();
cmd.CommandText = "Select Count(*) From PHANQUYEN where taikhoan='" + pqObj.Taikhoan + "'and matkhau='" + pqObj.MatKhau + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool UpdDataPQ(PhanQuyenObj pqObj)
{
cmd.CommandText = "Update PHANQUYEN set matkhau = '" + pqObj.MatKhau + "',phanquyen = '" + pqObj.Quyen + "', ghichu =N'" + pqObj.GhiChu + "' Where taikhoan = '" + pqObj.Taikhoan + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool AddDataPQ(PhanQuyenObj pqObj)
{
cmd.CommandText = "Insert into PHANQUYEN values ('" + pqObj.ID + "','" + pqObj.Taikhoan + "','" + pqObj.MatKhau + "','" + pqObj.Quyen + "','" + pqObj.maNhanVien + "',N'" + pqObj.GhiChu + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
con.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
void ganDulieuPQ(PhanQuyenObj pqObj)
{
pqObj.Taikhoan = txtTaiKhoan.Text.Trim();
pqObj.MatKhau = toMD5(txtMatKhau.Text);// txtMatKhau.Text.Trim();
}
public bool UpdDataPQ(PhanQuyenObj pqObj)
{
return(pqMod.UpdDataPQ(pqObj));
}
public bool checkNV(PhanQuyenObj pqObj)
{
return(pqMod.CheckNV(pqObj));
}
