public frmDM_ChucDanh(frmHoSoGiaoVien _frmHoSoGiaoVien)
{
InitializeComponent();
oBDM_ChucDanh = new cBDM_ChucDanh();
pDM_ChucDanhInfo = new DM_ChucDanhInfo();
SetControl(false);
ofrmHoSoGiaoVien = _frmHoSoGiaoVien;
}
public void Delete(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_ChucDanhID", SqlDbType.Int, pDM_ChucDanhInfo.DM_ChucDanhID));
RunProcedure("sp_DM_ChucDanh_Delete", colParam);
}
public DataTable Get(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_ChucDanhID", SqlDbType.Int, pDM_ChucDanhInfo.DM_ChucDanhID));
return(RunProcedureGet("sp_DM_ChucDanh_Get", colParam));
}
public int Add(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
int ID = 0;
ID = oDDM_ChucDanh.Add(pDM_ChucDanhInfo);
mErrorMessage = oDDM_ChucDanh.ErrorMessages;
mErrorNumber = oDDM_ChucDanh.ErrorNumber;
return(ID);
}
public void Update(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenChucDanh", SqlDbType.NVarChar, pDM_ChucDanhInfo.TenChucDanh));
colParam.Add(CreateParam("@DM_ChucDanhID", SqlDbType.Int, pDM_ChucDanhInfo.DM_ChucDanhID));
RunProcedure("sp_DM_ChucDanh_Update", colParam);
}
public int Add(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenChucDanh", SqlDbType.NVarChar, pDM_ChucDanhInfo.TenChucDanh));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_ChucDanh_Add", colParam));
}
public List <DM_ChucDanhInfo> GetList(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
List <DM_ChucDanhInfo> oDM_ChucDanhInfoList = new List <DM_ChucDanhInfo>();
DataTable dtb = Get(pDM_ChucDanhInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_ChucDanhInfo = new DM_ChucDanhInfo();
oDM_ChucDanhInfo.DM_ChucDanhID = int.Parse(dtb.Rows[i]["DM_ChucDanhID"].ToString());
oDM_ChucDanhInfo.TenChucDanh = dtb.Rows[i]["TenChucDanh"].ToString();
oDM_ChucDanhInfoList.Add(oDM_ChucDanhInfo);
}
}
return(oDM_ChucDanhInfoList);
}
public void ToInfo(ref DM_ChucDanhInfo pDM_ChucDanhInfo, DataRow dr)
{
pDM_ChucDanhInfo.DM_ChucDanhID = int.Parse(dr[pDM_ChucDanhInfo.strDM_ChucDanhID].ToString());
pDM_ChucDanhInfo.TenChucDanh = dr[pDM_ChucDanhInfo.strTenChucDanh].ToString();
}
public void ToDataRow(DM_ChucDanhInfo pDM_ChucDanhInfo, ref DataRow dr)
{
dr[pDM_ChucDanhInfo.strDM_ChucDanhID] = pDM_ChucDanhInfo.DM_ChucDanhID;
dr[pDM_ChucDanhInfo.strTenChucDanh] = pDM_ChucDanhInfo.TenChucDanh;
}
public void Delete(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
oDDM_ChucDanh.Delete(pDM_ChucDanhInfo);
mErrorMessage = oDDM_ChucDanh.ErrorMessages;
mErrorNumber = oDDM_ChucDanh.ErrorNumber;
}
public DataTable Get(DM_ChucDanhInfo pDM_ChucDanhInfo)
{
return(oDDM_ChucDanh.Get(pDM_ChucDanhInfo));
}
