public void ToDataRow(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo, ref DataRow dr)
{
dr[pSV_ThangRenLuyenTrongKyInfo.strSV_ThangRenLuyenTrongKyID] = pSV_ThangRenLuyenTrongKyInfo.SV_ThangRenLuyenTrongKyID;
dr[pSV_ThangRenLuyenTrongKyInfo.strIDDM_NamHoc] = pSV_ThangRenLuyenTrongKyInfo.IDDM_NamHoc;
dr[pSV_ThangRenLuyenTrongKyInfo.strHocKy] = pSV_ThangRenLuyenTrongKyInfo.HocKy;
dr[pSV_ThangRenLuyenTrongKyInfo.strThang] = pSV_ThangRenLuyenTrongKyInfo.Thang;
}
public void ToInfo(ref SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo, DataRow dr)
{
pSV_ThangRenLuyenTrongKyInfo.SV_ThangRenLuyenTrongKyID = int.Parse(dr[pSV_ThangRenLuyenTrongKyInfo.strSV_ThangRenLuyenTrongKyID].ToString());
pSV_ThangRenLuyenTrongKyInfo.IDDM_NamHoc = int.Parse(dr[pSV_ThangRenLuyenTrongKyInfo.strIDDM_NamHoc].ToString());
pSV_ThangRenLuyenTrongKyInfo.HocKy = int.Parse(dr[pSV_ThangRenLuyenTrongKyInfo.strHocKy].ToString());
pSV_ThangRenLuyenTrongKyInfo.Thang = int.Parse(dr[pSV_ThangRenLuyenTrongKyInfo.strThang].ToString());
}
public void Delete(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_ThangRenLuyenTrongKyID", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.SV_ThangRenLuyenTrongKyID));
RunProcedure("sp_SV_ThangRenLuyenTrongKy_Delete", colParam);
}
public DataTable Get(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_ThangRenLuyenTrongKyID", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.SV_ThangRenLuyenTrongKyID));
return(RunProcedureGet("sp_SV_ThangRenLuyenTrongKy_Get", colParam));
}
public int Add(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
int ID = 0;
ID = oDSV_ThangRenLuyenTrongKy.Add(pSV_ThangRenLuyenTrongKyInfo);
mErrorMessage = oDSV_ThangRenLuyenTrongKy.ErrorMessages;
mErrorNumber = oDSV_ThangRenLuyenTrongKy.ErrorNumber;
return(ID);
}
public dlgThemThangRenLuyen(ref DataTable _dtThang)
{
InitializeComponent();
oBSV_ThangRenLuyenTrongKy = new cBSV_ThangRenLuyenTrongKy();
pSV_ThangRenLuyenTrongKyInfo = new SV_ThangRenLuyenTrongKyInfo();
this.DialogResult = DialogResult.Cancel;
dtThang = _dtThang;
}
public void Update(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.HocKy));
colParam.Add(CreateParam("@Thang", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.Thang));
colParam.Add(CreateParam("@SV_ThangRenLuyenTrongKyID", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.SV_ThangRenLuyenTrongKyID));
RunProcedure("sp_SV_ThangRenLuyenTrongKy_Update", colParam);
}
public int Add(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.HocKy));
colParam.Add(CreateParam("@Thang", SqlDbType.Int, pSV_ThangRenLuyenTrongKyInfo.Thang));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_SV_ThangRenLuyenTrongKy_Add", colParam));
}
public List <SV_ThangRenLuyenTrongKyInfo> GetList(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
List <SV_ThangRenLuyenTrongKyInfo> oSV_ThangRenLuyenTrongKyInfoList = new List <SV_ThangRenLuyenTrongKyInfo>();
DataTable dtb = Get(pSV_ThangRenLuyenTrongKyInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oSV_ThangRenLuyenTrongKyInfo = new SV_ThangRenLuyenTrongKyInfo();
oSV_ThangRenLuyenTrongKyInfo.SV_ThangRenLuyenTrongKyID = int.Parse(dtb.Rows[i]["SV_ThangRenLuyenTrongKyID"].ToString());
oSV_ThangRenLuyenTrongKyInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oSV_ThangRenLuyenTrongKyInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oSV_ThangRenLuyenTrongKyInfo.Thang = int.Parse(dtb.Rows[i]["Thang"].ToString());
oSV_ThangRenLuyenTrongKyInfoList.Add(oSV_ThangRenLuyenTrongKyInfo);
}
}
return(oSV_ThangRenLuyenTrongKyInfoList);
}
public void Delete(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
oDSV_ThangRenLuyenTrongKy.Delete(pSV_ThangRenLuyenTrongKyInfo);
mErrorMessage = oDSV_ThangRenLuyenTrongKy.ErrorMessages;
mErrorNumber = oDSV_ThangRenLuyenTrongKy.ErrorNumber;
}
public DataTable Get(SV_ThangRenLuyenTrongKyInfo pSV_ThangRenLuyenTrongKyInfo)
{
return(oDSV_ThangRenLuyenTrongKy.Get(pSV_ThangRenLuyenTrongKyInfo));
}
