public void ToInfo(ref DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo, DataRow dr)
{
pDM_QuanHeGiaDinhInfo.DM_QuanHeGiaDinhID = int.Parse(dr[pDM_QuanHeGiaDinhInfo.strDM_QuanHeGiaDinhID].ToString());
pDM_QuanHeGiaDinhInfo.TenMoiQuanHe = dr[pDM_QuanHeGiaDinhInfo.strTenMoiQuanHe].ToString();
pDM_QuanHeGiaDinhInfo.Bo = bool.Parse(dr[pDM_QuanHeGiaDinhInfo.strBo].ToString());
pDM_QuanHeGiaDinhInfo.Me = bool.Parse(dr[pDM_QuanHeGiaDinhInfo.strMe].ToString());
}
public void ToDataRow(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo, ref DataRow dr)
{
dr[pDM_QuanHeGiaDinhInfo.strDM_QuanHeGiaDinhID] = pDM_QuanHeGiaDinhInfo.DM_QuanHeGiaDinhID;
dr[pDM_QuanHeGiaDinhInfo.strTenMoiQuanHe] = pDM_QuanHeGiaDinhInfo.TenMoiQuanHe;
dr[pDM_QuanHeGiaDinhInfo.strBo] = pDM_QuanHeGiaDinhInfo.Bo;
dr[pDM_QuanHeGiaDinhInfo.strMe] = pDM_QuanHeGiaDinhInfo.Me;
}
public frmDM_QuanHeGiaDinh(frmHoSoGiaoVien _frmHoSoGiaoVien)
{
InitializeComponent();
oBDM_QuanHeGiaDinh = new cBDM_QuanHeGiaDinh();
pDM_QuanHeGiaDinhInfo = new DM_QuanHeGiaDinhInfo();
SetControl(false);
ofrmHoSoGiaoVien = _frmHoSoGiaoVien;
}
public void Delete(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_QuanHeGiaDinhID", SqlDbType.Int, pDM_QuanHeGiaDinhInfo.DM_QuanHeGiaDinhID));
RunProcedure("sp_DM_QuanHeGiaDinh_Delete", colParam);
}
public DataTable Get(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_QuanHeGiaDinhID", SqlDbType.Int, pDM_QuanHeGiaDinhInfo.DM_QuanHeGiaDinhID));
return(RunProcedureGet("sp_DM_QuanHeGiaDinh_Get", colParam));
}
public int Add(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
int ID = 0;
ID = oDDM_QuanHeGiaDinh.Add(pDM_QuanHeGiaDinhInfo);
mErrorMessage = oDDM_QuanHeGiaDinh.ErrorMessages;
mErrorNumber = oDDM_QuanHeGiaDinh.ErrorNumber;
return(ID);
}
public void Update(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenMoiQuanHe", SqlDbType.NVarChar, pDM_QuanHeGiaDinhInfo.TenMoiQuanHe));
colParam.Add(CreateParam("@Bo", SqlDbType.Bit, pDM_QuanHeGiaDinhInfo.Bo));
colParam.Add(CreateParam("@Me", SqlDbType.Bit, pDM_QuanHeGiaDinhInfo.Me));
colParam.Add(CreateParam("@DM_QuanHeGiaDinhID", SqlDbType.Int, pDM_QuanHeGiaDinhInfo.DM_QuanHeGiaDinhID));
RunProcedure("sp_DM_QuanHeGiaDinh_Update", colParam);
}
public int Add(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenMoiQuanHe", SqlDbType.NVarChar, pDM_QuanHeGiaDinhInfo.TenMoiQuanHe));
colParam.Add(CreateParam("@Bo", SqlDbType.Bit, pDM_QuanHeGiaDinhInfo.Bo));
colParam.Add(CreateParam("@Me", SqlDbType.Bit, pDM_QuanHeGiaDinhInfo.Me));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_QuanHeGiaDinh_Add", colParam));
}
public List <DM_QuanHeGiaDinhInfo> GetList(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
List <DM_QuanHeGiaDinhInfo> oDM_QuanHeGiaDinhInfoList = new List <DM_QuanHeGiaDinhInfo>();
DataTable dtb = Get(pDM_QuanHeGiaDinhInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_QuanHeGiaDinhInfo = new DM_QuanHeGiaDinhInfo();
oDM_QuanHeGiaDinhInfo.DM_QuanHeGiaDinhID = int.Parse(dtb.Rows[i]["DM_QuanHeGiaDinhID"].ToString());
oDM_QuanHeGiaDinhInfo.TenMoiQuanHe = dtb.Rows[i]["TenMoiQuanHe"].ToString();
oDM_QuanHeGiaDinhInfo.Bo = bool.Parse(dtb.Rows[i]["Bo"].ToString());
oDM_QuanHeGiaDinhInfo.Me = bool.Parse(dtb.Rows[i]["Me"].ToString());
oDM_QuanHeGiaDinhInfoList.Add(oDM_QuanHeGiaDinhInfo);
}
}
return(oDM_QuanHeGiaDinhInfoList);
}
public void Delete(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
oDDM_QuanHeGiaDinh.Delete(pDM_QuanHeGiaDinhInfo);
mErrorMessage = oDDM_QuanHeGiaDinh.ErrorMessages;
mErrorNumber = oDDM_QuanHeGiaDinh.ErrorNumber;
}
public DataTable Get(DM_QuanHeGiaDinhInfo pDM_QuanHeGiaDinhInfo)
{
return(oDDM_QuanHeGiaDinh.Get(pDM_QuanHeGiaDinhInfo));
}
