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