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