public List <XL_KeHoachThucHanhInfo> GetList(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
List <XL_KeHoachThucHanhInfo> oXL_KeHoachThucHanhInfoList = new List <XL_KeHoachThucHanhInfo>();
DataTable dtb = Get(pXL_KeHoachThucHanhInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_KeHoachThucHanhInfo = new XL_KeHoachThucHanhInfo();
oXL_KeHoachThucHanhInfo.XL_KeHoachThucHanhID = int.Parse(dtb.Rows[i]["XL_KeHoachThucHanhID"].ToString());
oXL_KeHoachThucHanhInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
oXL_KeHoachThucHanhInfo.IDXL_MonHocTrongKy = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKy"].ToString());
oXL_KeHoachThucHanhInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oXL_KeHoachThucHanhInfo.IDDM_PhongHoc = int.Parse(dtb.Rows[i]["IDDM_PhongHoc"].ToString());
oXL_KeHoachThucHanhInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oXL_KeHoachThucHanhInfo.SoBuoi = int.Parse(dtb.Rows[i]["SoBuoi"].ToString());
oXL_KeHoachThucHanhInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString());
oXL_KeHoachThucHanhInfo.SoTo = int.Parse(dtb.Rows[i]["SoTo"].ToString());
oXL_KeHoachThucHanhInfo.IDXL_KeHoachThucHanhKyHieu = int.Parse("0" + dtb.Rows[i]["IDXL_KeHoachThucHanhKyHieu"]);
oXL_KeHoachThucHanhInfoList.Add(oXL_KeHoachThucHanhInfo);
}
}
return(oXL_KeHoachThucHanhInfoList);
}
public void Delete(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachThucHanhID", SqlDbType.Int, pXL_KeHoachThucHanhInfo.XL_KeHoachThucHanhID));
RunProcedure("sp_XL_KeHoachThucHanh_Delete", colParam);
}
public DataTable Get(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachThucHanhID", SqlDbType.Int, pXL_KeHoachThucHanhInfo.XL_KeHoachThucHanhID));
return(RunProcedureGet("sp_XL_KeHoachThucHanh_Get", colParam));
}
public int Add(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
int ID = 0;
ID = oDXL_KeHoachThucHanh.Add(pXL_KeHoachThucHanhInfo);
mErrorMessage = oDXL_KeHoachThucHanh.ErrorMessages;
mErrorNumber = oDXL_KeHoachThucHanh.ErrorNumber;
return(ID);
}
public dlgThemMonThucHanh(ref DataRow _drMonThucHanh, int _IDDM_Lop, DataRow _drMonKy, EDIT_MODE _edit)
{
InitializeComponent();
oBXL_KeHoachThucHanh = new cBXL_KeHoachThucHanh();
pXL_KeHoachThucHanhInfo = new XL_KeHoachThucHanhInfo();
edit = _edit;
IDDM_Lop = _IDDM_Lop;
drMonKy = _drMonKy;
drMonThucHanh = _drMonThucHanh;
this.DialogResult = DialogResult.Cancel;
}
public void ToInfo(ref XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo, DataRow dr)
{
pXL_KeHoachThucHanhInfo.XL_KeHoachThucHanhID = int.Parse(dr[pXL_KeHoachThucHanhInfo.strXL_KeHoachThucHanhID].ToString());
pXL_KeHoachThucHanhInfo.IDDM_Lop = int.Parse(dr[pXL_KeHoachThucHanhInfo.strIDDM_Lop].ToString());
pXL_KeHoachThucHanhInfo.IDXL_MonHocTrongKy = int.Parse(dr[pXL_KeHoachThucHanhInfo.strIDXL_MonHocTrongKy].ToString());
pXL_KeHoachThucHanhInfo.IDDM_MonHoc = int.Parse(dr[pXL_KeHoachThucHanhInfo.strIDDM_MonHoc].ToString());
pXL_KeHoachThucHanhInfo.IDDM_PhongHoc = int.Parse(dr[pXL_KeHoachThucHanhInfo.strIDDM_PhongHoc].ToString());
pXL_KeHoachThucHanhInfo.IDNS_GiaoVien = int.Parse(dr[pXL_KeHoachThucHanhInfo.strIDNS_GiaoVien].ToString());
pXL_KeHoachThucHanhInfo.SoBuoi = int.Parse(dr[pXL_KeHoachThucHanhInfo.strSoBuoi].ToString());
pXL_KeHoachThucHanhInfo.SoTiet = int.Parse(dr[pXL_KeHoachThucHanhInfo.strSoTiet].ToString());
pXL_KeHoachThucHanhInfo.SoTo = int.Parse(dr[pXL_KeHoachThucHanhInfo.strSoTo].ToString());
pXL_KeHoachThucHanhInfo.IDXL_KeHoachThucHanhKyHieu = int.Parse("0" + dr[pXL_KeHoachThucHanhInfo.strIDXL_KeHoachThucHanhKyHieu]);
}
public void Update(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDDM_PhongHoc));
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoBuoi", SqlDbType.Int, pXL_KeHoachThucHanhInfo.SoBuoi));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_KeHoachThucHanhInfo.SoTiet));
colParam.Add(CreateParam("@SoTo", SqlDbType.Int, pXL_KeHoachThucHanhInfo.SoTo));
colParam.Add(CreateParam("@IDXL_KeHoachThucHanhKyHieu", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDXL_KeHoachThucHanhKyHieu));
colParam.Add(CreateParam("@XL_KeHoachThucHanhID", SqlDbType.Int, pXL_KeHoachThucHanhInfo.XL_KeHoachThucHanhID));
RunProcedure("sp_XL_KeHoachThucHanh_Update", colParam);
}
public void ToDataRow(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo, ref DataRow dr, EDIT_MODE edit)
{
dr[pXL_KeHoachThucHanhInfo.strXL_KeHoachThucHanhID] = pXL_KeHoachThucHanhInfo.XL_KeHoachThucHanhID;
if (edit == EDIT_MODE.THEM)
{
dr[pXL_KeHoachThucHanhInfo.strIDDM_Lop] = pXL_KeHoachThucHanhInfo.IDDM_Lop;
dr[pXL_KeHoachThucHanhInfo.strIDXL_MonHocTrongKy] = pXL_KeHoachThucHanhInfo.IDXL_MonHocTrongKy;
dr[pXL_KeHoachThucHanhInfo.strIDDM_MonHoc] = pXL_KeHoachThucHanhInfo.IDDM_MonHoc;
}
dr[pXL_KeHoachThucHanhInfo.strIDDM_PhongHoc] = pXL_KeHoachThucHanhInfo.IDDM_PhongHoc;
dr[pXL_KeHoachThucHanhInfo.strIDNS_GiaoVien] = pXL_KeHoachThucHanhInfo.IDNS_GiaoVien;
dr[pXL_KeHoachThucHanhInfo.strSoBuoi] = pXL_KeHoachThucHanhInfo.SoBuoi;
dr[pXL_KeHoachThucHanhInfo.strSoTiet] = pXL_KeHoachThucHanhInfo.SoTiet;
dr[pXL_KeHoachThucHanhInfo.strSoTo] = pXL_KeHoachThucHanhInfo.SoTo;
dr[pXL_KeHoachThucHanhInfo.strIDXL_KeHoachThucHanhKyHieu] = pXL_KeHoachThucHanhInfo.IDXL_KeHoachThucHanhKyHieu;
}
public int Add(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDDM_Lop));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDDM_PhongHoc));
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoBuoi", SqlDbType.Int, pXL_KeHoachThucHanhInfo.SoBuoi));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_KeHoachThucHanhInfo.SoTiet));
colParam.Add(CreateParam("@SoTo", SqlDbType.Int, pXL_KeHoachThucHanhInfo.SoTo));
colParam.Add(CreateParam("@IDXL_KeHoachThucHanhKyHieu", SqlDbType.Int, pXL_KeHoachThucHanhInfo.IDXL_KeHoachThucHanhKyHieu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_KeHoachThucHanh_Add", colParam));
}
public void Delete(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
oDXL_KeHoachThucHanh.Delete(pXL_KeHoachThucHanhInfo);
mErrorMessage = oDXL_KeHoachThucHanh.ErrorMessages;
mErrorNumber = oDXL_KeHoachThucHanh.ErrorNumber;
}
public DataTable Get(XL_KeHoachThucHanhInfo pXL_KeHoachThucHanhInfo)
{
return(oDXL_KeHoachThucHanh.Get(pXL_KeHoachThucHanhInfo));
}
