public void Delete(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_UserGroup_ChucNangID", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.HT_UserGroup_ChucNangID));
RunProcedure("sp_HT_UserGroup_ChucNang_Delete", colParam);
}
public DataTable Get(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_UserGroup_ChucNangID", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.HT_UserGroup_ChucNangID));
return(RunProcedureGet("sp_HT_UserGroup_ChucNang_Get", colParam));
}
public int Add(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
int ID = 0;
ID = oDHT_UserGroup_ChucNang.Add(pHT_UserGroup_ChucNangInfo);
mErrorMessage = oDHT_UserGroup_ChucNang.ErrorMessages;
mErrorNumber = oDHT_UserGroup_ChucNang.ErrorNumber;
return(ID);
}
public void ToInfo(ref HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo, DataRow dr)
{
pHT_UserGroup_ChucNangInfo.HT_UserGroup_ChucNangID = int.Parse(dr[pHT_UserGroup_ChucNangInfo.strHT_UserGroup_ChucNangID].ToString());
pHT_UserGroup_ChucNangInfo.IDHT_UserGroup = int.Parse(dr[pHT_UserGroup_ChucNangInfo.strIDHT_UserGroup].ToString());
pHT_UserGroup_ChucNangInfo.IDHT_ChucNang = int.Parse(dr[pHT_UserGroup_ChucNangInfo.strIDHT_ChucNang].ToString());
pHT_UserGroup_ChucNangInfo.Xem = bool.Parse(dr[pHT_UserGroup_ChucNangInfo.strXem].ToString());
pHT_UserGroup_ChucNangInfo.Sua = bool.Parse(dr[pHT_UserGroup_ChucNangInfo.strSua].ToString());
pHT_UserGroup_ChucNangInfo.Xoa = bool.Parse(dr[pHT_UserGroup_ChucNangInfo.strXoa].ToString());
pHT_UserGroup_ChucNangInfo.Them = bool.Parse(dr[pHT_UserGroup_ChucNangInfo.strThem].ToString());
}
public void ToDataRow(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo, ref DataRow dr)
{
dr[pHT_UserGroup_ChucNangInfo.strHT_UserGroup_ChucNangID] = pHT_UserGroup_ChucNangInfo.HT_UserGroup_ChucNangID;
dr[pHT_UserGroup_ChucNangInfo.strIDHT_UserGroup] = pHT_UserGroup_ChucNangInfo.IDHT_UserGroup;
dr[pHT_UserGroup_ChucNangInfo.strIDHT_ChucNang] = pHT_UserGroup_ChucNangInfo.IDHT_ChucNang;
dr[pHT_UserGroup_ChucNangInfo.strXem] = pHT_UserGroup_ChucNangInfo.Xem;
dr[pHT_UserGroup_ChucNangInfo.strSua] = pHT_UserGroup_ChucNangInfo.Sua;
dr[pHT_UserGroup_ChucNangInfo.strXoa] = pHT_UserGroup_ChucNangInfo.Xoa;
dr[pHT_UserGroup_ChucNangInfo.strThem] = pHT_UserGroup_ChucNangInfo.Them;
}
public dlgChucNang(int mHT_UserID, int mHT_UserGroupID)
{
InitializeComponent();
this.Tag = "";
oBHT_ChucNang = new cBHT_ChucNang();
oBNhom_ChucNang = new cBHT_UserGroup_ChucNang();
pNhom_ChucNangInfo = new HT_UserGroup_ChucNangInfo();
pUser_ChucNangInfo = new HT_User_ChucNangInfo();
oBUser_ChucNang = new cBHT_User_ChucNang();
HT_UserID = mHT_UserID;
HT_UserGroupID = mHT_UserGroupID;
}
public void Update(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDHT_UserGroup", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.IDHT_UserGroup));
colParam.Add(CreateParam("@IDHT_ChucNang", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.IDHT_ChucNang));
colParam.Add(CreateParam("@Xem", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Xem));
colParam.Add(CreateParam("@Sua", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Sua));
colParam.Add(CreateParam("@Xoa", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Xoa));
colParam.Add(CreateParam("@Them", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Them));
colParam.Add(CreateParam("@HT_UserGroup_ChucNangID", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.HT_UserGroup_ChucNangID));
RunProcedure("sp_HT_UserGroup_ChucNang_Update", colParam);
}
public int Add(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDHT_UserGroup", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.IDHT_UserGroup));
colParam.Add(CreateParam("@IDHT_ChucNang", SqlDbType.Int, pHT_UserGroup_ChucNangInfo.IDHT_ChucNang));
colParam.Add(CreateParam("@Xem", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Xem));
colParam.Add(CreateParam("@Sua", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Sua));
colParam.Add(CreateParam("@Xoa", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Xoa));
colParam.Add(CreateParam("@Them", SqlDbType.Bit, pHT_UserGroup_ChucNangInfo.Them));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_UserGroup_ChucNang_Add", colParam));
}
public List <HT_UserGroup_ChucNangInfo> GetList(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
List <HT_UserGroup_ChucNangInfo> oHT_UserGroup_ChucNangInfoList = new List <HT_UserGroup_ChucNangInfo>();
DataTable dtb = Get(pHT_UserGroup_ChucNangInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_UserGroup_ChucNangInfo = new HT_UserGroup_ChucNangInfo();
oHT_UserGroup_ChucNangInfo.HT_UserGroup_ChucNangID = int.Parse(dtb.Rows[i]["HT_UserGroup_ChucNangID"].ToString());
oHT_UserGroup_ChucNangInfo.IDHT_UserGroup = int.Parse(dtb.Rows[i]["IDHT_UserGroup"].ToString());
oHT_UserGroup_ChucNangInfo.IDHT_ChucNang = int.Parse(dtb.Rows[i]["IDHT_ChucNang"].ToString());
oHT_UserGroup_ChucNangInfo.Xem = bool.Parse(dtb.Rows[i]["Xem"].ToString());
oHT_UserGroup_ChucNangInfo.Sua = bool.Parse(dtb.Rows[i]["Sua"].ToString());
oHT_UserGroup_ChucNangInfo.Xoa = bool.Parse(dtb.Rows[i]["Xoa"].ToString());
oHT_UserGroup_ChucNangInfo.Them = bool.Parse(dtb.Rows[i]["Them"].ToString());
oHT_UserGroup_ChucNangInfoList.Add(oHT_UserGroup_ChucNangInfo);
}
}
return(oHT_UserGroup_ChucNangInfoList);
}
public void Delete(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
oDHT_UserGroup_ChucNang.Delete(pHT_UserGroup_ChucNangInfo);
mErrorMessage = oDHT_UserGroup_ChucNang.ErrorMessages;
mErrorNumber = oDHT_UserGroup_ChucNang.ErrorNumber;
}
public DataTable Get(HT_UserGroup_ChucNangInfo pHT_UserGroup_ChucNangInfo)
{
return(oDHT_UserGroup_ChucNang.Get(pHT_UserGroup_ChucNangInfo));
}
