public DataSet taocombo()
{
clsdmchucvu c = new clsdmchucvu();
c.sc.Open();
string sql1 = "Select * from tbl_DMChucVu";
SqlCommand scmd = new SqlCommand(sql1, c.sc);
c.sda.SelectCommand = scmd;
c.sda.Fill(c.ds, "DMChucVu");
c.sc.Close();
return(c.ds);
}
public string laytenTo(string maTo)
{
if (maTo == "")
{
return("");
}
clsdmchucvu c = new clsdmchucvu();
c.sc.Open();
string sql1 = "Select TenTo from tbl_DanhMucTo where MaTo='" + maTo + "'";
SqlCommand scmd = new SqlCommand(sql1, c.sc);
object ten = scmd.ExecuteScalar();
c.sc.Close();
return(ten.ToString());
}
//lấy tên chức vụ từ mã chức vụ
public string laytenCV(string macv)
{
if (macv == "")
{
return("");
}
clsdmchucvu c = new clsdmchucvu();
c.sc.Open();
string sql1 = "Select tenchucvu from tbl_DMChucVu where machucvu='" + macv + "'";
SqlCommand scmd = new SqlCommand(sql1, c.sc);
object ten = scmd.ExecuteScalar();
c.sc.Close();
return(ten.ToString());
}
public string laytenPB(string ma)
{
if (ma == "")
{
return("");
}
clsdmchucvu c = new clsdmchucvu();
c.sc.Open();
string sql1 = "Select TenPhong from tbl_PhongBan where MaPhong='" + ma + "'";
SqlCommand scmd = new SqlCommand(sql1, c.sc);
object ten = scmd.ExecuteScalar();
c.sc.Close();
return(ten.ToString());
}