public DataTable GetDanhSach(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <sp_XL_GiaoVien_MonHoc_GetDanhSachResult>(client.cDXL_GiaoVien_MonHoc_GetDanhSach(GlobalVar.MaXacThuc, pXL_GiaoVien_MonHocInfo))); } }
public DataTable GetDanhSach(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien)); return(RunProcedureGet("sp_XL_GiaoVien_MonHoc_GetDanhSach", colParam)); }
public void Delete(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@XL_GiaoVien_MonHocID", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID)); RunProcedure("sp_XL_GiaoVien_MonHoc_Delete", colParam); }
public DataTable Get(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@XL_GiaoVien_MonHocID", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID)); return(RunProcedureGet("sp_XL_GiaoVien_MonHoc_Get", colParam)); }
public int Add(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { int ID = 0; ID = oDXL_GiaoVien_MonHoc.Add(pXL_GiaoVien_MonHocInfo); mErrorMessage = oDXL_GiaoVien_MonHoc.ErrorMessages; mErrorNumber = oDXL_GiaoVien_MonHoc.ErrorNumber; return(ID); }
public void Update(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@XL_GiaoVien_MonHocID", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID)); RunProcedure("sp_XL_GiaoVien_MonHoc_Update", colParam); }
public int Add(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDDM_MonHoc)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_XL_GiaoVien_MonHoc_Add", colParam)); }
public frmPhanCongGiangDay() { InitializeComponent(); repositoryHinhThucThi.DataSource = LoadHinhThucThi(); oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc(); pXL_GiaoVien_MonHocInfo = new XL_GiaoVien_MonHocInfo(); oBXL_PhanCongGiaoVien = new cBXL_PhanCongGiaoVien(); pXL_PhanCongGiaoVienInfo = new XL_PhanCongGiaoVienInfo(); oBNS_GiaoVien = new cBNS_GiaoVien(); }
public frmDanhSachGiaoVien() { InitializeComponent(); oBGiaoVien = new cBNS_GiaoVien(); pGiaoVienInfo = new NS_GiaoVienInfo(); pDonViInfo = new NS_DonViInfo(); oBXL_GV_MH = new cBXL_GiaoVien_MonHoc(); pXL_GV_MHInfo = new XL_GiaoVien_MonHocInfo(); repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinh(); }
public dlgChonMonHoc(int mIDNS_GiaoVien, string mHoTen) { InitializeComponent(); oBDM_MonHoc = new cBDM_MonHoc(); pDM_MonHocInfo = new DM_MonHocInfo(); oBXL_GV_MH = new cBXL_GiaoVien_MonHoc(); pXL_GV_MHInfo = new XL_GiaoVien_MonHocInfo(); pXL_GV_MHInfo.IDNS_GiaoVien = mIDNS_GiaoVien; HoTen = mHoTen; this.Tag = ""; }
public List <XL_GiaoVien_MonHocInfo> GetList(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { List <XL_GiaoVien_MonHocInfo> oXL_GiaoVien_MonHocInfoList = new List <XL_GiaoVien_MonHocInfo>(); DataTable dtb = Get(pXL_GiaoVien_MonHocInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oXL_GiaoVien_MonHocInfo = new XL_GiaoVien_MonHocInfo(); oXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID = int.Parse(dtb.Rows[i]["XL_GiaoVien_MonHocID"].ToString()); oXL_GiaoVien_MonHocInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString()); oXL_GiaoVien_MonHocInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString()); oXL_GiaoVien_MonHocInfoList.Add(oXL_GiaoVien_MonHocInfo); } } return(oXL_GiaoVien_MonHocInfoList); }
public dlgThemMonHoc_LopTach(string mXL_LopTachGopIDs, int mIDDM_Lop, int mIDXL_MonHocTrongKy, string mIDXL_MonHocTrongKys, bool mCheckTach_Gop, string mIDDM_Lops, int mSoLop) { InitializeComponent(); oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc(); oBXL_LopTachGop_MonHoc = new cBXL_LopTachGop_MonHoc(); oBXL_LopTachGop = new cBXL_LopTachGop(); pXL_GiaoVien_MonHocInfo = new XL_GiaoVien_MonHocInfo(); pXL_LopTachGop_MonHocInfo = new XL_LopTachGop_MonHocInfo(); CheckTach_Gop = mCheckTach_Gop; XL_LopTachGopIDs = mXL_LopTachGopIDs; IDXL_MonHocTrongKy = mIDXL_MonHocTrongKy; IDXL_MonHocTrongKys = mIDXL_MonHocTrongKys; // them mon hoc - lop tach if (CheckTach_Gop == false) { dtMonHoc = MonHocTrongKyGetAll(mIDDM_Lop); IDDM_Lop = mIDDM_Lop; } else { // them mon hoc - lop gop dtMonHocAll = MonHocTrongKyGetByLopGop(mIDDM_Lops, mSoLop); Lib.clsDataTableHelper cls = new Lib.clsDataTableHelper(); dtMonHoc = cls.SelectDistinct(dtMonHocAll, new string[] { "IDDM_MonHoc", "TenMonHoc", "MaMonHoc", "IDNS_GiaoVien", "IDDM_PhongHoc", "Cahocs", "Chon" }); IDDM_Lops = mIDDM_Lops; char[] mChar = { ',' }; ArrayLop = IDDM_Lops.Split(mChar); IDDM_Lop = int.Parse(XL_LopTachGopIDs.Substring(0, XL_LopTachGopIDs.IndexOf(","))); SoLop = mSoLop; } dtMonHoc.AcceptChanges(); repositoryPhongHoc.DataSource = LoadPhongHoc(); this.Tag = ""; }
public void ToInfo(ref XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo, DataRow dr) { pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID = int.Parse(dr[pXL_GiaoVien_MonHocInfo.strXL_GiaoVien_MonHocID].ToString()); pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien = int.Parse(dr[pXL_GiaoVien_MonHocInfo.strIDNS_GiaoVien].ToString()); pXL_GiaoVien_MonHocInfo.IDDM_MonHoc = int.Parse(dr[pXL_GiaoVien_MonHocInfo.strIDDM_MonHoc].ToString()); }
public void ToDataRow(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo, ref DataRow dr) { dr[pXL_GiaoVien_MonHocInfo.strXL_GiaoVien_MonHocID] = pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID; dr[pXL_GiaoVien_MonHocInfo.strIDNS_GiaoVien] = pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien; dr[pXL_GiaoVien_MonHocInfo.strIDDM_MonHoc] = pXL_GiaoVien_MonHocInfo.IDDM_MonHoc; }
public void Delete(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { oDXL_GiaoVien_MonHoc.Delete(pXL_GiaoVien_MonHocInfo); mErrorMessage = oDXL_GiaoVien_MonHoc.ErrorMessages; mErrorNumber = oDXL_GiaoVien_MonHoc.ErrorNumber; }
public DataTable GetDanhSach(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo) { return(oDXL_GiaoVien_MonHoc.GetDanhSach(pXL_GiaoVien_MonHocInfo)); }