public DataTable Get(HT_UserGroupInfo pHT_UserGroupInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_UserGroupID", SqlDbType.Int, pHT_UserGroupInfo.HT_UserGroupID));
return(RunProcedureGet("sp_HT_UserGroup_Get", colParam));
}
public void Delete(HT_UserGroupInfo pHT_UserGroupInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_UserGroupID", SqlDbType.Int, pHT_UserGroupInfo.HT_UserGroupID));
RunProcedure("sp_HT_UserGroup_Delete", colParam);
}
public frmNhomNguoiDung()
{
InitializeComponent();
pHT_ChucNangInfo = new HT_ChucNangInfo();
oBHT_ChucNang = new cBHT_ChucNang();
oBHT_UserGroup = new cBHT_UserGroup();
pHT_UserGroupInfo = new HT_UserGroupInfo();
}
public void Update(HT_UserGroupInfo pHT_UserGroupInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenNhom", SqlDbType.NVarChar, pHT_UserGroupInfo.TenNhom));
colParam.Add(CreateParam("@HT_UserGroupID", SqlDbType.Int, pHT_UserGroupInfo.HT_UserGroupID));
RunProcedure("sp_HT_UserGroup_Update", colParam);
}
public int Add(HT_UserGroupInfo pHT_UserGroupInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenNhom", SqlDbType.NVarChar, pHT_UserGroupInfo.TenNhom));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_UserGroup_Add", colParam));
}
public int Add(HT_UserGroupInfo pHT_UserGroupInfo)
{
int ID = 0;
ID = oDHT_UserGroup.Add(pHT_UserGroupInfo);
mErrorMessage = oDHT_UserGroup.ErrorMessages;
mErrorNumber = oDHT_UserGroup.ErrorNumber;
return(ID);
}
public List <HT_UserGroupInfo> GetList(HT_UserGroupInfo pHT_UserGroupInfo)
{
List <HT_UserGroupInfo> oHT_UserGroupInfoList = new List <HT_UserGroupInfo>();
DataTable dtb = Get(pHT_UserGroupInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_UserGroupInfo = new HT_UserGroupInfo();
oHT_UserGroupInfo.HT_UserGroupID = int.Parse(dtb.Rows[i]["HT_UserGroupID"].ToString());
oHT_UserGroupInfo.TenNhom = dtb.Rows[i]["TenNhom"].ToString();
oHT_UserGroupInfoList.Add(oHT_UserGroupInfo);
}
}
return(oHT_UserGroupInfoList);
}
public void ToInfo(ref HT_UserGroupInfo pHT_UserGroupInfo, DataRow dr)
{
pHT_UserGroupInfo.HT_UserGroupID = int.Parse(dr[pHT_UserGroupInfo.strHT_UserGroupID].ToString());
pHT_UserGroupInfo.TenNhom = dr[pHT_UserGroupInfo.strTenNhom].ToString();
}
public void ToDataRow(HT_UserGroupInfo pHT_UserGroupInfo, ref DataRow dr)
{
dr[pHT_UserGroupInfo.strHT_UserGroupID] = pHT_UserGroupInfo.HT_UserGroupID;
dr[pHT_UserGroupInfo.strTenNhom] = pHT_UserGroupInfo.TenNhom;
}
public void Delete(HT_UserGroupInfo pHT_UserGroupInfo)
{
oDHT_UserGroup.Delete(pHT_UserGroupInfo);
mErrorMessage = oDHT_UserGroup.ErrorMessages;
mErrorNumber = oDHT_UserGroup.ErrorNumber;
}
public DataTable Get(HT_UserGroupInfo pHT_UserGroupInfo)
{
return(oDHT_UserGroup.Get(pHT_UserGroupInfo));
}
