public DataTable Get(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_CTDT_ChiTiet_GetResult>(client.cDKQHT_CTDT_ChiTiet_Get(GlobalVar.MaXacThuc, pKQHT_CTDT_ChiTietInfo)));
}
}
public List <KQHT_CTDT_ChiTietInfo> GetList(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
List <KQHT_CTDT_ChiTietInfo> oKQHT_CTDT_ChiTietInfoList = new List <KQHT_CTDT_ChiTietInfo>();
DataTable dtb = Get(pKQHT_CTDT_ChiTietInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_CTDT_ChiTietInfo = new KQHT_CTDT_ChiTietInfo();
oKQHT_CTDT_ChiTietInfo.KQHT_CTDT_ChiTietID = long.Parse(dtb.Rows[i]["KQHT_CTDT_ChiTietID"].ToString());
oKQHT_CTDT_ChiTietInfo.IDKQHT_MonHoc_CT_KhoiKienThuc = int.Parse(dtb.Rows[i]["IDKQHT_MonHoc_CT_KhoiKienThuc"].ToString());
oKQHT_CTDT_ChiTietInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_CTDT_ChiTietInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString());
oKQHT_CTDT_ChiTietInfo.LyThuyet = int.Parse(dtb.Rows[i]["LyThuyet"].ToString());
oKQHT_CTDT_ChiTietInfo.ThucHanh = int.Parse(dtb.Rows[i]["ThucHanh"].ToString());
oKQHT_CTDT_ChiTietInfo.LoaiTietKhac1 = int.Parse(dtb.Rows[i]["LoaiTietKhac1"].ToString());
oKQHT_CTDT_ChiTietInfo.LoaiTietKhac2 = int.Parse(dtb.Rows[i]["LoaiTietKhac2"].ToString());
oKQHT_CTDT_ChiTietInfo.SoHocTrinh = double.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());
oKQHT_CTDT_ChiTietInfoList.Add(oKQHT_CTDT_ChiTietInfo);
}
}
return(oKQHT_CTDT_ChiTietInfoList);
}
public void Delete(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_CTDT_ChiTietID", SqlDbType.BigInt, pKQHT_CTDT_ChiTietInfo.KQHT_CTDT_ChiTietID));
RunProcedure("sp_KQHT_CTDT_ChiTiet_Delete", colParam);
}
public DataTable Get(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_CTDT_ChiTietID", SqlDbType.BigInt, pKQHT_CTDT_ChiTietInfo.KQHT_CTDT_ChiTietID));
return(RunProcedureGet("sp_KQHT_CTDT_ChiTiet_Get", colParam));
}
public int Add(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
int ID = 0;
ID = oDKQHT_CTDT_ChiTiet.Add(pKQHT_CTDT_ChiTietInfo);
mErrorMessage = oDKQHT_CTDT_ChiTiet.ErrorMessages;
mErrorNumber = oDKQHT_CTDT_ChiTiet.ErrorNumber;
return(ID);
}
public void DeleteByHocKy(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_CTDT_ChiTiet_DeleteByHocKy(GlobalVar.MaXacThuc, pKQHT_CTDT_ChiTietInfo);
client.Close();
mErrorMessage = oDKQHT_CTDT_ChiTiet.ErrorMessages;
mErrorNumber = oDKQHT_CTDT_ChiTiet.ErrorNumber;
}
public int Add(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_CTDT_ChiTiet_Add(GlobalVar.MaXacThuc, pKQHT_CTDT_ChiTietInfo);
client.Close();
mErrorMessage = oDKQHT_CTDT_ChiTiet.ErrorMessages;
mErrorNumber = oDKQHT_CTDT_ChiTiet.ErrorNumber;
return(ID);
}
public void ToDataRow(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo, ref DataRow dr)
{
dr[pKQHT_CTDT_ChiTietInfo.strKQHT_CTDT_ChiTietID] = pKQHT_CTDT_ChiTietInfo.KQHT_CTDT_ChiTietID;
dr[pKQHT_CTDT_ChiTietInfo.strIDKQHT_MonHoc_CT_KhoiKienThuc] = pKQHT_CTDT_ChiTietInfo.IDKQHT_MonHoc_CT_KhoiKienThuc;
dr[pKQHT_CTDT_ChiTietInfo.strHocKy] = pKQHT_CTDT_ChiTietInfo.HocKy;
dr[pKQHT_CTDT_ChiTietInfo.strSoTiet] = pKQHT_CTDT_ChiTietInfo.SoTiet;
dr[pKQHT_CTDT_ChiTietInfo.strLyThuyet] = pKQHT_CTDT_ChiTietInfo.LyThuyet;
dr[pKQHT_CTDT_ChiTietInfo.strThucHanh] = pKQHT_CTDT_ChiTietInfo.ThucHanh;
dr[pKQHT_CTDT_ChiTietInfo.strLoaiTietKhac1] = pKQHT_CTDT_ChiTietInfo.LoaiTietKhac1;
dr[pKQHT_CTDT_ChiTietInfo.strLoaiTietKhac2] = pKQHT_CTDT_ChiTietInfo.LoaiTietKhac2;
dr[pKQHT_CTDT_ChiTietInfo.strSoHocTrinh] = pKQHT_CTDT_ChiTietInfo.SoHocTrinh;
}
public void Update(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_MonHoc_CT_KhoiKienThuc", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.IDKQHT_MonHoc_CT_KhoiKienThuc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.HocKy));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.SoTiet));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.LyThuyet));
colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.ThucHanh));
colParam.Add(CreateParam("@LoaiTietKhac1", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.LoaiTietKhac1));
colParam.Add(CreateParam("@LoaiTietKhac2", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.LoaiTietKhac2));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pKQHT_CTDT_ChiTietInfo.SoHocTrinh));
colParam.Add(CreateParam("@KQHT_CTDT_ChiTietID", SqlDbType.BigInt, pKQHT_CTDT_ChiTietInfo.KQHT_CTDT_ChiTietID));
RunProcedure("sp_KQHT_CTDT_ChiTiet_Update", colParam);
}
public int Add(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_MonHoc_CT_KhoiKienThuc", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.IDKQHT_MonHoc_CT_KhoiKienThuc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.HocKy));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.SoTiet));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.LyThuyet));
colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.ThucHanh));
colParam.Add(CreateParam("@LoaiTietKhac1", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.LoaiTietKhac1));
colParam.Add(CreateParam("@LoaiTietKhac2", SqlDbType.Int, pKQHT_CTDT_ChiTietInfo.LoaiTietKhac2));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pKQHT_CTDT_ChiTietInfo.SoHocTrinh));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_CTDT_ChiTiet_Add", colParam));
}
public void DeleteByHocKy(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
oDKQHT_CTDT_ChiTiet.DeleteByHocKy(pKQHT_CTDT_ChiTietInfo);
mErrorMessage = oDKQHT_CTDT_ChiTiet.ErrorMessages;
mErrorNumber = oDKQHT_CTDT_ChiTiet.ErrorNumber;
}
public void Update(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
oDKQHT_CTDT_ChiTiet.Update(pKQHT_CTDT_ChiTietInfo);
mErrorMessage = oDKQHT_CTDT_ChiTiet.ErrorMessages;
mErrorNumber = oDKQHT_CTDT_ChiTiet.ErrorNumber;
}
public DataTable Get(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
return(oDKQHT_CTDT_ChiTiet.Get(pKQHT_CTDT_ChiTietInfo));
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
if (grvMonHoc.DataRowCount > 0)
{
DataTable dtTemp = dtMonHoc.GetChanges();
string ErrMonHoc = "";
if (dtTemp != null)
{
try
{
foreach (DataRow dr in dtTemp.Rows)
{
ErrMonHoc = dr["TenMonHoc"].ToString();
for (int j = 1; j <= pKQHT_ChuongTrinhDaoTaoInfo.SoHocKy; j++)
{
pKQHT_CTDT_ChiTiet = new KQHT_CTDT_ChiTietInfo();
pKQHT_CTDT_ChiTiet.IDKQHT_MonHoc_CT_KhoiKienThuc = int.Parse(dr["IDKQHT_MonHoc_CT_KhoiKienThuc"].ToString());
pKQHT_CTDT_ChiTiet.HocKy = j;
// Nếu IDj khác null thì update, hoặc xóa khi các số liệu còn lại bằng 0
// Ngược lại thì insert nếu một trong các các số liệu còn lại > 0
if (int.Parse("0" + dr["ID" + j.ToString()]) != 0)
{
pKQHT_CTDT_ChiTiet.KQHT_CTDT_ChiTietID = int.Parse(dr["ID" + j.ToString()].ToString());
// Nếu tất cả các số liệu đều null hoặc bằng 0 thì xóa, ngược lại thì update
if (float.Parse("0" + dr["SHT" + j.ToString()]) == 0 && int.Parse("0" + dr["LT" + j.ToString()]) == 0 && int.Parse("0" + dr["TH" + j.ToString()]) == 0)
{
oBKQHT_CTDT_ChiTiet.DeleteByHocKy(pKQHT_CTDT_ChiTiet);
}
else
{
pKQHT_CTDT_ChiTiet.SoTiet = 0;
pKQHT_CTDT_ChiTiet.SoHocTrinh = dr["SHT" + j.ToString()] == null ? 0 : float.Parse(dr["SHT" + j.ToString()].ToString());
if (int.Parse("0" + dr["LT" + j.ToString()]) != 0)
{
pKQHT_CTDT_ChiTiet.LyThuyet = int.Parse(dr["LT" + j.ToString()].ToString());
pKQHT_CTDT_ChiTiet.SoTiet += pKQHT_CTDT_ChiTiet.LyThuyet;
}
if (int.Parse("0" + dr["TH" + j.ToString()]) != 0)
{
pKQHT_CTDT_ChiTiet.ThucHanh = int.Parse(dr["TH" + j.ToString()].ToString());
pKQHT_CTDT_ChiTiet.SoTiet += pKQHT_CTDT_ChiTiet.ThucHanh;
}
oBKQHT_CTDT_ChiTiet.Update(pKQHT_CTDT_ChiTiet);
}
}
else
{
if (float.Parse("0" + dr["SHT" + j.ToString()]) != 0 || int.Parse("0" + dr["LT" + j.ToString()]) != 0 || int.Parse("0" + dr["TH" + j.ToString()]) != 0)
{
pKQHT_CTDT_ChiTiet.SoTiet = 0;
pKQHT_CTDT_ChiTiet.SoHocTrinh = float.Parse("0" + dr["SHT" + j.ToString()]) == 0 ? 0 : float.Parse(dr["SHT" + j.ToString()].ToString());
if (int.Parse("0" + dr["LT" + j.ToString()]) != 0)
{
pKQHT_CTDT_ChiTiet.LyThuyet = int.Parse(dr["LT" + j.ToString()].ToString());
pKQHT_CTDT_ChiTiet.SoTiet += pKQHT_CTDT_ChiTiet.LyThuyet;
}
if (int.Parse("0" + dr["TH" + j.ToString()]) != 0)
{
pKQHT_CTDT_ChiTiet.ThucHanh = int.Parse(dr["TH" + j.ToString()].ToString());
pKQHT_CTDT_ChiTiet.SoTiet += pKQHT_CTDT_ChiTiet.ThucHanh;
}
oBKQHT_CTDT_ChiTiet.Add(pKQHT_CTDT_ChiTiet);
}
}
}
}
// ghi log
//GhiLog("Cập nhật thông tin môn học trong chương trình đào tạo '" + pKQHT_ChuongTrinhDaoTaoInfo.TenChuongTrinhDaoTao + "'", "Cập nhật", this.Tag.ToString());
//LoadCTDTChiTiet(pKQHT_ChuongTrinhDaoTaoInfo.KQHT_ChuongTrinhDaoTaoID, pKQHT_ChuongTrinhDaoTaoInfo.SoHocKy);
}
catch
{
ThongBaoLoi("Có lỗi khi cập nhật, có thể là môn học '" + ErrMonHoc + "' đã được sử dụng trong môn học trong kỳ.");
}
// ghi log
GhiLog("Cập nhật thông tin môn học trong chương trình đào tạo '" + pKQHT_ChuongTrinhDaoTaoInfo.TenChuongTrinhDaoTao + "'", "Cập nhật", this.Tag.ToString());
LoadCTDTChiTiet(pKQHT_ChuongTrinhDaoTaoInfo.KQHT_ChuongTrinhDaoTaoID, pKQHT_ChuongTrinhDaoTaoInfo.SoHocKy);
}
}
}
