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)); }