public void ToInfo(ref GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo, DataRow dr) { pGG_GiangDayGiaoVienInfo.GG_GiangDayGiaoVienID = long.Parse(dr[pGG_GiangDayGiaoVienInfo.strGG_GiangDayGiaoVienID].ToString()); pGG_GiangDayGiaoVienInfo.IDNS_GiaoVien = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strIDNS_GiaoVien].ToString()); pGG_GiangDayGiaoVienInfo.IDDM_NamHoc = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strIDDM_NamHoc].ToString()); pGG_GiangDayGiaoVienInfo.HocKy = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strHocKy].ToString()); pGG_GiangDayGiaoVienInfo.IDXL_MonHocTrongKy = long.Parse(dr[pGG_GiangDayGiaoVienInfo.strIDXL_MonHocTrongKy].ToString()); pGG_GiangDayGiaoVienInfo.SoNhom = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strSoNhom].ToString()); pGG_GiangDayGiaoVienInfo.SoSinhVien = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strSoSinhVien].ToString()); if ("" + dr[pGG_GiangDayGiaoVienInfo.strLyThuyet] != "") { pGG_GiangDayGiaoVienInfo.LyThuyet = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strLyThuyet].ToString()); } if ("" + dr[pGG_GiangDayGiaoVienInfo.strLyThuyetQuyChuan] != "") { pGG_GiangDayGiaoVienInfo.LyThuyetQuyChuan = double.Parse(dr[pGG_GiangDayGiaoVienInfo.strLyThuyetQuyChuan].ToString()); } if ("" + dr[pGG_GiangDayGiaoVienInfo.strThucHanh] != "") { pGG_GiangDayGiaoVienInfo.ThucHanh = int.Parse(dr[pGG_GiangDayGiaoVienInfo.strThucHanh].ToString()); } if ("" + dr[pGG_GiangDayGiaoVienInfo.strThucHanhQuyChuan] != "") { pGG_GiangDayGiaoVienInfo.ThucHanhQuyChuan = double.Parse(dr[pGG_GiangDayGiaoVienInfo.strThucHanhQuyChuan].ToString()); } pGG_GiangDayGiaoVienInfo.SoGioChuan = double.Parse(dr[pGG_GiangDayGiaoVienInfo.strSoGioChuan].ToString()); if ("" + dr[pGG_GiangDayGiaoVienInfo.strGhiChu] != "") { pGG_GiangDayGiaoVienInfo.GhiChu = dr[pGG_GiangDayGiaoVienInfo.strGhiChu].ToString(); } }
private void GetpGiangDayGiaoVienInfo(DataRow dr) { pGG_GiangDayGiaoVienInfo = new GG_GiangDayGiaoVienInfo(); pGG_GiangDayGiaoVienInfo.IDNS_GiaoVien = int.Parse(dr["NS_GiaoVienID"].ToString()); pGG_GiangDayGiaoVienInfo.IDXL_MonHocTrongKy = long.Parse(dr["XL_MonHocTrongKyID"].ToString()); pGG_GiangDayGiaoVienInfo.IDDM_NamHoc = Program.IDNamHoc; pGG_GiangDayGiaoVienInfo.HocKy = Program.HocKy; if ("" + dr["SoSinhVien"] != "") { pGG_GiangDayGiaoVienInfo.SoSinhVien = int.Parse(dr["SoSinhVien"].ToString()); } if ("" + dr["LyThuyet"] != "") { pGG_GiangDayGiaoVienInfo.LyThuyet = int.Parse(dr["LyThuyet"].ToString()); } if ("" + dr["LyThuyetQuyChuan"] != "") { pGG_GiangDayGiaoVienInfo.LyThuyetQuyChuan = double.Parse(dr["LyThuyetQuyChuan"].ToString()); } if ("" + dr["ThucHanh"] != "") { pGG_GiangDayGiaoVienInfo.ThucHanh = int.Parse(dr["ThucHanh"].ToString()); } if ("" + dr["ThucHanhQuyChuan"] != "") { pGG_GiangDayGiaoVienInfo.ThucHanhQuyChuan = double.Parse(dr["ThucHanhQuyChuan"].ToString()); } pGG_GiangDayGiaoVienInfo.SoGioChuan = double.Parse(dr["GioQuyChuan"].ToString()); pGG_GiangDayGiaoVienInfo.GhiChu = "" + dr["GhiChu"]; }
public void Delete(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@GG_GiangDayGiaoVienID", SqlDbType.BigInt, pGG_GiangDayGiaoVienInfo.GG_GiangDayGiaoVienID)); RunProcedure("sp_GG_GiangDayGiaoVien_Delete", colParam); }
public DataTable Get(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@GG_GiangDayGiaoVienID", SqlDbType.BigInt, pGG_GiangDayGiaoVienInfo.GG_GiangDayGiaoVienID)); return(RunProcedureGet("sp_GG_GiangDayGiaoVien_Get", colParam)); }
public long UpdateAdd(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { long ID = 0; ID = oDGG_GiangDayGiaoVien.UpdateAdd(pGG_GiangDayGiaoVienInfo); mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages; mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber; return(ID); }
//public long Add(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) //{ // long ID = 0; // var client = new UnimOsServiceClient(); // ID = client.cDGG_GiangDayGiaoVien_Add(GlobalVar.MaXacThuc, pGG_GiangDayGiaoVienInfo); // client.Close(); // mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages; // mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber; // return ID; //} //public void Update(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) //{ // var client = new UnimOsServiceClient(); // client.cDGG_GiangDayGiaoVien_Update(GlobalVar.MaXacThuc, pGG_GiangDayGiaoVienInfo); // client.Close(); // mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages; // mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber; //} public long UpdateAdd(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { long ID = 0; var client = new UnimOsServiceClient(); ID = client.cDGG_GiangDayGiaoVien_UpdateAdd(GlobalVar.MaXacThuc, pGG_GiangDayGiaoVienInfo); client.Close(); mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages; mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber; return(ID); }
public void ToDataRow(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo, ref DataRow dr) { dr[pGG_GiangDayGiaoVienInfo.strGG_GiangDayGiaoVienID] = pGG_GiangDayGiaoVienInfo.GG_GiangDayGiaoVienID; dr[pGG_GiangDayGiaoVienInfo.strIDNS_GiaoVien] = pGG_GiangDayGiaoVienInfo.IDNS_GiaoVien; dr[pGG_GiangDayGiaoVienInfo.strIDDM_NamHoc] = pGG_GiangDayGiaoVienInfo.IDDM_NamHoc; dr[pGG_GiangDayGiaoVienInfo.strHocKy] = pGG_GiangDayGiaoVienInfo.HocKy; dr[pGG_GiangDayGiaoVienInfo.strIDXL_MonHocTrongKy] = pGG_GiangDayGiaoVienInfo.IDXL_MonHocTrongKy; dr[pGG_GiangDayGiaoVienInfo.strSoNhom] = pGG_GiangDayGiaoVienInfo.SoNhom; dr[pGG_GiangDayGiaoVienInfo.strSoSinhVien] = pGG_GiangDayGiaoVienInfo.SoSinhVien; dr[pGG_GiangDayGiaoVienInfo.strLyThuyet] = pGG_GiangDayGiaoVienInfo.LyThuyet; dr[pGG_GiangDayGiaoVienInfo.strLyThuyetQuyChuan] = pGG_GiangDayGiaoVienInfo.LyThuyetQuyChuan; dr[pGG_GiangDayGiaoVienInfo.strThucHanh] = pGG_GiangDayGiaoVienInfo.ThucHanh; dr[pGG_GiangDayGiaoVienInfo.strThucHanhQuyChuan] = pGG_GiangDayGiaoVienInfo.ThucHanhQuyChuan; dr[pGG_GiangDayGiaoVienInfo.strSoGioChuan] = pGG_GiangDayGiaoVienInfo.SoGioChuan; dr[pGG_GiangDayGiaoVienInfo.strGhiChu] = pGG_GiangDayGiaoVienInfo.GhiChu; }
public List <GG_GiangDayGiaoVienInfo> GetList(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { List <GG_GiangDayGiaoVienInfo> oGG_GiangDayGiaoVienInfoList = new List <GG_GiangDayGiaoVienInfo>(); DataTable dtb = Get(pGG_GiangDayGiaoVienInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { pGG_GiangDayGiaoVienInfo = new GG_GiangDayGiaoVienInfo(); pGG_GiangDayGiaoVienInfo.GG_GiangDayGiaoVienID = long.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strGG_GiangDayGiaoVienID].ToString()); pGG_GiangDayGiaoVienInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strIDNS_GiaoVien].ToString()); pGG_GiangDayGiaoVienInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strIDDM_NamHoc].ToString()); pGG_GiangDayGiaoVienInfo.HocKy = int.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strHocKy].ToString()); pGG_GiangDayGiaoVienInfo.IDXL_MonHocTrongKy = long.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strIDXL_MonHocTrongKy].ToString()); pGG_GiangDayGiaoVienInfo.SoSinhVien = int.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strSoSinhVien].ToString()); if ("" + dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strLyThuyet] != "") { pGG_GiangDayGiaoVienInfo.LyThuyet = int.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strLyThuyet].ToString()); } if ("" + dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strLyThuyetQuyChuan] != "") { pGG_GiangDayGiaoVienInfo.LyThuyetQuyChuan = double.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strLyThuyetQuyChuan].ToString()); } if ("" + dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strThucHanh] != "") { pGG_GiangDayGiaoVienInfo.ThucHanh = int.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strThucHanh].ToString()); } if ("" + dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strThucHanhQuyChuan] != "") { pGG_GiangDayGiaoVienInfo.ThucHanhQuyChuan = double.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strThucHanhQuyChuan].ToString()); } pGG_GiangDayGiaoVienInfo.SoGioChuan = double.Parse(dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strSoGioChuan].ToString()); if ("" + dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strGhiChu] != "") { pGG_GiangDayGiaoVienInfo.GhiChu = dtb.Rows[i][pGG_GiangDayGiaoVienInfo.strGhiChu].ToString(); } oGG_GiangDayGiaoVienInfoList.Add(pGG_GiangDayGiaoVienInfo); } } return(oGG_GiangDayGiaoVienInfoList); }
public long UpdateAdd(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.HocKy)); colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.BigInt, pGG_GiangDayGiaoVienInfo.IDXL_MonHocTrongKy)); colParam.Add(CreateParam("@SoNhom", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.SoNhom)); colParam.Add(CreateParam("@SoSinhVien", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.SoSinhVien)); colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.LyThuyet)); colParam.Add(CreateParam("@LyThuyetQuyChuan", SqlDbType.Float, pGG_GiangDayGiaoVienInfo.LyThuyetQuyChuan)); colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pGG_GiangDayGiaoVienInfo.ThucHanh)); colParam.Add(CreateParam("@ThucHanhQuyChuan", SqlDbType.Float, pGG_GiangDayGiaoVienInfo.ThucHanhQuyChuan)); colParam.Add(CreateParam("@HeSoLopDong", SqlDbType.Float, pGG_GiangDayGiaoVienInfo.HeSoLopDong)); colParam.Add(CreateParam("@SoGioChuan", SqlDbType.Float, pGG_GiangDayGiaoVienInfo.SoGioChuan)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pGG_GiangDayGiaoVienInfo.GhiChu)); colParam.Add(CreateParamOut("@ID", SqlDbType.BigInt)); return((long)RunProcedureOut("sp_GG_GiangDayGiaoVien_UpdateAdd", colParam)); }
public frmGioGiangGiaoVien() { InitializeComponent(); oBGG_CongViecGiaoVien = new cBGG_CongViecGiaoVien(); pGG_CongViecGiaoVienInfo = new GG_CongViecGiaoVienInfo(); oBGG_GiangDayGiaoVien = new cBGG_GiangDayGiaoVien(); pGG_GiangDayGiaoVienInfo = new GG_GiangDayGiaoVienInfo(); cmbDonVi.Properties.DataSource = LoadDonVi(); // Thực hiện tính tổng theo group this.grvGioGiang.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] { new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, "TongTiet", this.grcTongTiet, "{0:#,###}"), new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, "LyThuyet", this.grcLyThuyet, "{0:#,###}"), new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, "ThucHanh", this.grcThucHanh, "{0:#,###}"), new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, "GioQuyChuan", this.grcGioChuan, "{0:#,###.##}"), new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, "LyThuyetQuyDoi", this.grcLyThuyeQuyDoi, "{0:#,###.##}"), new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum, "ThucHanhQuyDoi", this.grcThucHanhQuyDoi, "{0:#,###.##}") }); cBHT_ThamSoHeThong oBHT_ThamSoHeThong = new cBHT_ThamSoHeThong(); SoGioThucHanhTrongTuan = int.Parse(oBHT_ThamSoHeThong.GetGiaTriByMaThamSo("SoTietThucHanhTrong1Tuan")); SoTietQuyDoiThucHanhTrongTuan = int.Parse(oBHT_ThamSoHeThong.GetGiaTriByMaThamSo("SoTietQuyDoiThucHanhTrongTuan")); }
public void Delete(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { oDGG_GiangDayGiaoVien.Delete(pGG_GiangDayGiaoVienInfo); mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages; mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber; }
public DataTable Get(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo) { return(oDGG_GiangDayGiaoVien.Get(pGG_GiangDayGiaoVienInfo)); }