public List <HT_UserInfo> GetList(HT_UserInfo pHT_UserInfo) { List <HT_UserInfo> oHT_UserInfoList = new List <HT_UserInfo>(); DataTable dtb = Get(pHT_UserInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oHT_UserInfo = new HT_UserInfo(); oHT_UserInfo.HT_UserID = int.Parse(dtb.Rows[i]["HT_UserID"].ToString()); oHT_UserInfo.UserName = dtb.Rows[i]["UserName"].ToString(); oHT_UserInfo.Password = dtb.Rows[i]["Password"].ToString(); oHT_UserInfo.FullName = dtb.Rows[i]["FullName"].ToString(); oHT_UserInfo.IDNS_GiaoVien = "" + dtb.Rows[i]["IDNS_GiaoVien"] == "" ? 0 : int.Parse("" + dtb.Rows[i]["IDNS_GiaoVien"]); oHT_UserInfo.IDHT_UserGroup = "" + dtb.Rows[i]["IDHT_UserGroup"] == "" ? 0 : int.Parse("" + dtb.Rows[i]["IDHT_UserGroup"]); oHT_UserInfo.Active = bool.Parse(dtb.Rows[i]["Active"].ToString()); oHT_UserInfo.IpAddress = dtb.Rows[i]["IpAddress"].ToString(); oHT_UserInfo.MacAddress = dtb.Rows[i]["MacAddress"].ToString(); oHT_UserInfoList.Add(oHT_UserInfo); } } return(oHT_UserInfoList); }
public void Delete(HT_UserInfo pHT_UserInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@HT_UserID", SqlDbType.Int, pHT_UserInfo.HT_UserID)); RunProcedure("sp_HT_User_Delete", colParam); }
public DataTable Get(HT_UserInfo pHT_UserInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@HT_UserID", SqlDbType.Int, pHT_UserInfo.HT_UserID)); return(RunProcedureGet("sp_HT_User_Get", colParam)); }
public int Add(HT_UserInfo pHT_UserInfo) { int ID = 0; ID = oDHT_User.Add(pHT_UserInfo); mErrorMessage = oDHT_User.ErrorMessages; mErrorNumber = oDHT_User.ErrorNumber; return(ID); }
public frmQuanLyNguoiDung() { InitializeComponent(); oBNS_GiaoVien = new cBNS_GiaoVien(); pHT_UserInfo = new HT_UserInfo(); oBHT_User = new cBHT_User(); pHT_ChucNangInfo = new HT_ChucNangInfo(); oBHT_ChucNang = new cBHT_ChucNang(); }
public void ToDataRow(HT_UserInfo pHT_UserInfo, ref DataRow dr) { dr[pHT_UserInfo.strHT_UserID] = pHT_UserInfo.HT_UserID; dr[pHT_UserInfo.strUserName] = pHT_UserInfo.UserName; dr[pHT_UserInfo.strPassword] = pHT_UserInfo.Password; dr[pHT_UserInfo.strFullName] = pHT_UserInfo.FullName; dr[pHT_UserInfo.strIDNS_GiaoVien] = pHT_UserInfo.IDNS_GiaoVien; dr[pHT_UserInfo.strIDHT_UserGroup] = pHT_UserInfo.IDHT_UserGroup; dr[pHT_UserInfo.strActive] = pHT_UserInfo.Active; dr[pHT_UserInfo.strIpAddress] = pHT_UserInfo.IpAddress; dr[pHT_UserInfo.strMacAddress] = pHT_UserInfo.MacAddress; }
public frmTraCuuLog() { InitializeComponent(); oBPhanHe = new cBHT_PhanHe(); pPhanHeInfo = new HT_PhanHeInfo(); oBChucNang = new cBHT_ChucNang(); pChucNangInfo = new HT_ChucNangInfo(); pHT_LogInfo = new HT_LogInfo(); oBHT_Log = new cBHT_Log(); pHT_UserInfo = new HT_UserInfo(); oBHT_User = new cBHT_User(); }
public void Update(HT_UserInfo pHT_UserInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@UserName", SqlDbType.NVarChar, pHT_UserInfo.UserName)); colParam.Add(CreateParam("@Password", SqlDbType.NVarChar, pHT_UserInfo.Password)); colParam.Add(CreateParam("@FullName", SqlDbType.NVarChar, pHT_UserInfo.FullName)); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pHT_UserInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@IDHT_UserGroup", SqlDbType.Int, pHT_UserInfo.IDHT_UserGroup)); colParam.Add(CreateParam("@Active", SqlDbType.Bit, pHT_UserInfo.Active)); colParam.Add(CreateParam("@IpAddress", SqlDbType.NVarChar, pHT_UserInfo.IpAddress)); colParam.Add(CreateParam("@MacAddress", SqlDbType.NVarChar, pHT_UserInfo.MacAddress)); colParam.Add(CreateParam("@HT_UserID", SqlDbType.Int, pHT_UserInfo.HT_UserID)); RunProcedure("sp_HT_User_Update", colParam); }
public int Add(HT_UserInfo pHT_UserInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@UserName", SqlDbType.NVarChar, pHT_UserInfo.UserName)); colParam.Add(CreateParam("@Password", SqlDbType.NVarChar, pHT_UserInfo.Password)); colParam.Add(CreateParam("@FullName", SqlDbType.NVarChar, pHT_UserInfo.FullName)); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pHT_UserInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@IDHT_UserGroup", SqlDbType.Int, pHT_UserInfo.IDHT_UserGroup)); colParam.Add(CreateParam("@Active", SqlDbType.Bit, pHT_UserInfo.Active)); colParam.Add(CreateParam("@IpAddress", SqlDbType.NVarChar, pHT_UserInfo.IpAddress)); colParam.Add(CreateParam("@MacAddress", SqlDbType.NVarChar, pHT_UserInfo.MacAddress)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_HT_User_Add", colParam)); }
public void ToInfo(ref HT_UserInfo pHT_UserInfo, DataRow dr) { pHT_UserInfo.HT_UserID = int.Parse(dr[pHT_UserInfo.strHT_UserID].ToString()); pHT_UserInfo.UserName = dr[pHT_UserInfo.strUserName].ToString(); pHT_UserInfo.Password = dr[pHT_UserInfo.strPassword].ToString(); pHT_UserInfo.FullName = dr[pHT_UserInfo.strFullName].ToString(); if ("" + dr[pHT_UserInfo.strIDNS_GiaoVien] != "") { pHT_UserInfo.IDNS_GiaoVien = int.Parse(dr[pHT_UserInfo.strIDNS_GiaoVien].ToString()); } if ("" + dr[pHT_UserInfo.strIDHT_UserGroup] != "") { pHT_UserInfo.IDHT_UserGroup = int.Parse(dr[pHT_UserInfo.strIDHT_UserGroup].ToString()); } pHT_UserInfo.Active = bool.Parse(dr[pHT_UserInfo.strActive].ToString()); pHT_UserInfo.IpAddress = "" + dr[pHT_UserInfo.strIpAddress].ToString(); pHT_UserInfo.MacAddress = "" + dr[pHT_UserInfo.strMacAddress].ToString(); }
public void Delete(HT_UserInfo pHT_UserInfo) { oDHT_User.Delete(pHT_UserInfo); mErrorMessage = oDHT_User.ErrorMessages; mErrorNumber = oDHT_User.ErrorNumber; }
public DataTable Get(HT_UserInfo pHT_UserInfo) { return(oDHT_User.Get(pHT_UserInfo)); }
public frmLogIn() { InitializeComponent(); oBHT_User = new cBHT_User(); pHT_UserInfo = new HT_UserInfo(); }