public List <GG_CongViecGiaoVienInfo> GetList(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { List <GG_CongViecGiaoVienInfo> oGG_CongViecGiaoVienInfoList = new List <GG_CongViecGiaoVienInfo>(); DataTable dtb = Get(pGG_CongViecGiaoVienInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { pGG_CongViecGiaoVienInfo = new GG_CongViecGiaoVienInfo(); pGG_CongViecGiaoVienInfo.GG_CongViecGiaoVienID = int.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strGG_CongViecGiaoVienID].ToString()); pGG_CongViecGiaoVienInfo.IDDM_LoaiCongViec = int.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strIDDM_LoaiCongViec].ToString()); pGG_CongViecGiaoVienInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strIDNS_GiaoVien].ToString()); pGG_CongViecGiaoVienInfo.SoGio = int.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strSoGio].ToString()); pGG_CongViecGiaoVienInfo.HeSo = double.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strHeSo].ToString()); pGG_CongViecGiaoVienInfo.GioQuyChuan = double.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strGioQuyChuan].ToString()); pGG_CongViecGiaoVienInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strIDDM_NamHoc].ToString()); pGG_CongViecGiaoVienInfo.HocKy = int.Parse(dtb.Rows[i][pGG_CongViecGiaoVienInfo.strHocKy].ToString()); if ("" + dtb.Rows[i][pGG_CongViecGiaoVienInfo.strGhiChu] != "") { pGG_CongViecGiaoVienInfo.GhiChu = dtb.Rows[i][pGG_CongViecGiaoVienInfo.strGhiChu].ToString(); } oGG_CongViecGiaoVienInfoList.Add(pGG_CongViecGiaoVienInfo); } } return(oGG_CongViecGiaoVienInfoList); }
public DataTable Get(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <sp_GG_CongViecGiaoVien_GetResult>(client.cDGG_CongViecGiaoVien_Get_2(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo))); } }
public void Delete(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@GG_CongViecGiaoVienID", SqlDbType.Int, pGG_CongViecGiaoVienInfo.GG_CongViecGiaoVienID)); RunProcedure("sp_GG_CongViecGiaoVien_Delete", colParam); }
public DataTable Get(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@GG_CongViecGiaoVienID", SqlDbType.Int, pGG_CongViecGiaoVienInfo.GG_CongViecGiaoVienID)); return(RunProcedureGet("sp_GG_CongViecGiaoVien_Get", colParam)); }
public long UpdateAdd(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { long ID = 0; ID = oDGG_CongViecGiaoVien.UpdateAdd(pGG_CongViecGiaoVienInfo); mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages; mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber; return(ID); }
public frmNhapCongViecGiaoVien() { InitializeComponent(); oBGGCongViecGiaoVien = new cBGG_CongViecGiaoVien(); pCongViecGiaoVienInfo = new GG_CongViecGiaoVienInfo(); pDonViInfo = new NS_DonViInfo(); oBLoaiCongViec = new cBDM_LoaiCongViec(); dtNhiemVu = oBLoaiCongViec.Get(new DM_LoaiCongViecInfo()); cmbNhiemVu.Properties.DataSource = dtNhiemVu; }
//public long Add(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) //{ // long ID = 0; // var client = new UnimOsServiceClient(); // ID = client.cDGG_CongViecGiaoVien_Add(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo); // client.Close(); // mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages; // mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber; // return ID; //} //public void Update(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) //{ // var client = new UnimOsServiceClient(); // client.cDGG_CongViecGiaoVien_Update(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo); // client.Close(); // mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages; // mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber; //} public long UpdateAdd(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { long ID = 0; var client = new UnimOsServiceClient(); ID = client.cDGG_CongViecGiaoVien_UpdateAdd(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo); client.Close(); mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages; mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber; return(ID); }
public void ToDataRow(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo, ref DataRow dr) { dr[pGG_CongViecGiaoVienInfo.strGG_CongViecGiaoVienID] = pGG_CongViecGiaoVienInfo.GG_CongViecGiaoVienID; dr[pGG_CongViecGiaoVienInfo.strIDDM_LoaiCongViec] = pGG_CongViecGiaoVienInfo.IDDM_LoaiCongViec; dr[pGG_CongViecGiaoVienInfo.strIDNS_GiaoVien] = pGG_CongViecGiaoVienInfo.IDNS_GiaoVien; dr[pGG_CongViecGiaoVienInfo.strSoGio] = pGG_CongViecGiaoVienInfo.SoGio; dr[pGG_CongViecGiaoVienInfo.strHeSo] = pGG_CongViecGiaoVienInfo.HeSo; dr[pGG_CongViecGiaoVienInfo.strGioQuyChuan] = pGG_CongViecGiaoVienInfo.GioQuyChuan; dr[pGG_CongViecGiaoVienInfo.strIDDM_NamHoc] = pGG_CongViecGiaoVienInfo.IDDM_NamHoc; dr[pGG_CongViecGiaoVienInfo.strHocKy] = pGG_CongViecGiaoVienInfo.HocKy; dr[pGG_CongViecGiaoVienInfo.strGhiChu] = pGG_CongViecGiaoVienInfo.GhiChu; }
public void ToInfo(ref GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo, DataRow dr) { pGG_CongViecGiaoVienInfo.GG_CongViecGiaoVienID = int.Parse(dr[pGG_CongViecGiaoVienInfo.strGG_CongViecGiaoVienID].ToString()); pGG_CongViecGiaoVienInfo.IDDM_LoaiCongViec = int.Parse(dr[pGG_CongViecGiaoVienInfo.strIDDM_LoaiCongViec].ToString()); pGG_CongViecGiaoVienInfo.IDNS_GiaoVien = int.Parse(dr[pGG_CongViecGiaoVienInfo.strIDNS_GiaoVien].ToString()); pGG_CongViecGiaoVienInfo.SoGio = int.Parse(dr[pGG_CongViecGiaoVienInfo.strSoGio].ToString()); pGG_CongViecGiaoVienInfo.HeSo = double.Parse(dr[pGG_CongViecGiaoVienInfo.strHeSo].ToString()); pGG_CongViecGiaoVienInfo.GioQuyChuan = double.Parse(dr[pGG_CongViecGiaoVienInfo.strGioQuyChuan].ToString()); pGG_CongViecGiaoVienInfo.IDDM_NamHoc = int.Parse(dr[pGG_CongViecGiaoVienInfo.strIDDM_NamHoc].ToString()); pGG_CongViecGiaoVienInfo.HocKy = int.Parse(dr[pGG_CongViecGiaoVienInfo.strHocKy].ToString()); if ("" + dr[pGG_CongViecGiaoVienInfo.strGhiChu] != "") { pGG_CongViecGiaoVienInfo.GhiChu = dr[pGG_CongViecGiaoVienInfo.strGhiChu].ToString(); } }
public long UpdateAdd(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDDM_LoaiCongViec", SqlDbType.Int, pGG_CongViecGiaoVienInfo.IDDM_LoaiCongViec)); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pGG_CongViecGiaoVienInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@SoGio", SqlDbType.Float, pGG_CongViecGiaoVienInfo.SoGio)); colParam.Add(CreateParam("@HeSo", SqlDbType.Float, pGG_CongViecGiaoVienInfo.HeSo)); colParam.Add(CreateParam("@GioQuyChuan", SqlDbType.Float, pGG_CongViecGiaoVienInfo.GioQuyChuan)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pGG_CongViecGiaoVienInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pGG_CongViecGiaoVienInfo.HocKy)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pGG_CongViecGiaoVienInfo.GhiChu)); colParam.Add(CreateParamOut("@ID", SqlDbType.BigInt)); return((long)RunProcedureOut("sp_GG_CongViecGiaoVien_UpdateAdd", colParam)); }
public void Update(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDDM_LoaiCongViec", SqlDbType.Int, pGG_CongViecGiaoVienInfo.IDDM_LoaiCongViec)); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pGG_CongViecGiaoVienInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@SoGio", SqlDbType.Float, pGG_CongViecGiaoVienInfo.SoGio)); colParam.Add(CreateParam("@HeSo", SqlDbType.Float, pGG_CongViecGiaoVienInfo.HeSo)); colParam.Add(CreateParam("@GioQuyChuan", SqlDbType.Float, pGG_CongViecGiaoVienInfo.GioQuyChuan)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pGG_CongViecGiaoVienInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pGG_CongViecGiaoVienInfo.HocKy)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pGG_CongViecGiaoVienInfo.GhiChu)); colParam.Add(CreateParam("@GG_CongViecGiaoVienID", SqlDbType.Int, pGG_CongViecGiaoVienInfo.GG_CongViecGiaoVienID)); RunProcedure("sp_GG_CongViecGiaoVien_Update", colParam); }
private void GetpCongViecGiaoVienInfo(DataRow dr) { pGG_CongViecGiaoVienInfo = new GG_CongViecGiaoVienInfo(); pGG_CongViecGiaoVienInfo.IDNS_GiaoVien = int.Parse(dr["NS_GiaoVienID"].ToString()); pGG_CongViecGiaoVienInfo.IDDM_LoaiCongViec = int.Parse(dr["DM_LoaiCongViecID"].ToString()); pGG_CongViecGiaoVienInfo.IDDM_NamHoc = Program.IDNamHoc; pGG_CongViecGiaoVienInfo.HocKy = Program.HocKy; if ("" + dr["TongTiet"] != "") { pGG_CongViecGiaoVienInfo.SoGio = double.Parse(dr["TongTiet"].ToString()); } if ("" + dr["HeSo"] != "") { pGG_CongViecGiaoVienInfo.HeSo = double.Parse(dr["HeSo"].ToString()); } pGG_CongViecGiaoVienInfo.GioQuyChuan = double.Parse(dr["GioQuyChuan"].ToString()); pGG_CongViecGiaoVienInfo.GhiChu = "" + dr["GhiChu"]; }
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_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { oDGG_CongViecGiaoVien.Delete(pGG_CongViecGiaoVienInfo); mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages; mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber; }
public DataTable Get(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo) { return(oDGG_CongViecGiaoVien.Get(pGG_CongViecGiaoVienInfo)); }