public void ToDataRow(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo, ref DataRow dr)
{
dr[pKQHT_XepLoaiMonHocInfo.strKQHT_XepLoaiMonHocID] = pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID;
dr[pKQHT_XepLoaiMonHocInfo.strTenXepLoai] = pKQHT_XepLoaiMonHocInfo.TenXepLoai;
dr[pKQHT_XepLoaiMonHocInfo.strTuDiem] = pKQHT_XepLoaiMonHocInfo.TuDiem;
dr[pKQHT_XepLoaiMonHocInfo.strMaXepLoai] = pKQHT_XepLoaiMonHocInfo.MaXepLoai;
}
public void ToInfo(ref KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo, DataRow dr)
{
pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID = int.Parse(dr[pKQHT_XepLoaiMonHocInfo.strKQHT_XepLoaiMonHocID].ToString());
pKQHT_XepLoaiMonHocInfo.TenXepLoai = dr[pKQHT_XepLoaiMonHocInfo.strTenXepLoai].ToString();
pKQHT_XepLoaiMonHocInfo.TuDiem = double.Parse(dr[pKQHT_XepLoaiMonHocInfo.strTuDiem].ToString());
pKQHT_XepLoaiMonHocInfo.MaXepLoai = dr[pKQHT_XepLoaiMonHocInfo.strMaXepLoai].ToString();
}
public DataTable Get(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_XepLoaiMonHoc_GetResult>(client.cDKQHT_XepLoaiMonHoc_Get(GlobalVar.MaXacThuc, pKQHT_XepLoaiMonHocInfo)));
}
}
public void Delete(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_XepLoaiMonHocID", SqlDbType.Int, pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID));
RunProcedure("sp_KQHT_XepLoaiMonHoc_Delete", colParam);
}
public DataTable Get(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_XepLoaiMonHocID", SqlDbType.Int, pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID));
return(RunProcedureGet("sp_KQHT_XepLoaiMonHoc_Get", colParam));
}
public int Add(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
int ID = 0;
ID = oDKQHT_XepLoaiMonHoc.Add(pKQHT_XepLoaiMonHocInfo);
mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages;
mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber;
return(ID);
}
public void Delete(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_XepLoaiMonHoc_Delete(GlobalVar.MaXacThuc, pKQHT_XepLoaiMonHocInfo);
client.Close();
mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages;
mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber;
}
public void Update(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.TenXepLoai));
colParam.Add(CreateParam("@TuDiem", SqlDbType.Float, pKQHT_XepLoaiMonHocInfo.TuDiem));
colParam.Add(CreateParam("@MaXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.MaXepLoai));
colParam.Add(CreateParam("@KQHT_XepLoaiMonHocID", SqlDbType.Int, pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID));
RunProcedure("sp_KQHT_XepLoaiMonHoc_Update", colParam);
}
public int Add(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.TenXepLoai));
colParam.Add(CreateParam("@TuDiem", SqlDbType.Float, pKQHT_XepLoaiMonHocInfo.TuDiem));
colParam.Add(CreateParam("@MaXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.MaXepLoai));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_XepLoaiMonHoc_Add", colParam));
}
public int Add(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_XepLoaiMonHoc_Add(GlobalVar.MaXacThuc, pKQHT_XepLoaiMonHocInfo);
client.Close();
mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages;
mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber;
return(ID);
}
public List <KQHT_XepLoaiMonHocInfo> GetList(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
List <KQHT_XepLoaiMonHocInfo> oKQHT_XepLoaiMonHocInfoList = new List <KQHT_XepLoaiMonHocInfo>();
DataTable dtb = Get(pKQHT_XepLoaiMonHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_XepLoaiMonHocInfo = new KQHT_XepLoaiMonHocInfo();
oKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID = int.Parse(dtb.Rows[i]["KQHT_XepLoaiMonHocID"].ToString());
oKQHT_XepLoaiMonHocInfo.TenXepLoai = dtb.Rows[i]["TenXepLoai"].ToString();
oKQHT_XepLoaiMonHocInfo.TuDiem = double.Parse(dtb.Rows[i]["TuDiem"].ToString());
oKQHT_XepLoaiMonHocInfo.MaXepLoai = dtb.Rows[i]["MaXepLoai"].ToString();
oKQHT_XepLoaiMonHocInfoList.Add(oKQHT_XepLoaiMonHocInfo);
}
}
return(oKQHT_XepLoaiMonHocInfoList);
}
private void btnInBangDiem_Click(object sender, EventArgs e)
{
if (grvLichSu.FocusedRowHandle < 0)
{
ThongBao("Bạn chưa chọn lần nhập lại điểm nào !");
return;
}
// Lấy danh sách sinh viên
dtSinhVien = CreateTable();
AddBand();
XuLyTable((int)grvLichSu.GetDataRow(grvLichSu.FocusedRowHandle)["KQHT_ChoNhapLaiDiemID"]);
if (dtSinhVien.Rows.Count <= 0)
{
ThongBao("Không có dữ liệu để in báo cáo !");
return;
}
DataTable dtMain = oBKQHT_DiemThanhPhan.CreateTableReportMain();
DataRow dr = dtMain.NewRow();
dr["TenMonHoc"] = drMonHoc["TenMonHoc"];
dr["TenLop"] = pDM_LopInfo.TenLop.Replace("Lớp: ", "");
dr["HocKy"] = Program.HocKy;
dr["NamHoc"] = Program.NamHoc;
dr["SoTiet"] = drMonHoc["SoTiet"];
#region Tổng hợp Xếp loại
// Đưa dữ liệu phần tỷ lệ kết quả học tập
DataTable dtXepLoai;
cBKQHT_XepLoaiMonHoc oBKQHT_XepLoaiMonHoc = new cBKQHT_XepLoaiMonHoc();
KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo = new KQHT_XepLoaiMonHocInfo();
int SoSinhVien;
dtXepLoai = oBKQHT_XepLoaiMonHoc.Get(pKQHT_XepLoaiMonHocInfo);
//dr = dtMain.NewRow();
SoSinhVien = dtSinhVien.Rows.Count;
// Tỷ lệ giỏi
string Condition = "";
int SoLuong = 0;
DataRow[] ArrDr = dtXepLoai.Select("MaXepLoai = 'G'");
if (ArrDr.Length > 0)
{
Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"];
//foreach (DataRow drXL in ArrDr)
//{
// Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"];
//}
SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString());
dr["LoaiGioi"] = TinhPhanTram(SoLuong, SoSinhVien);
}
// Tỷ lệ khá
ArrDr = dtXepLoai.Select("MaXepLoai = 'K'");
if (ArrDr.Length > 0)
{
Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"];
//foreach (DataRow drXL in ArrDr)
//{
// Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"];
//}
SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString());
dr["LoaiKha"] = TinhPhanTram(SoLuong, SoSinhVien);
}
// Tỷ lệ trung bình
ArrDr = dtXepLoai.Select("MaXepLoai = 'TB'");
if (ArrDr.Length > 0)
{
Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"];
//foreach (DataRow drXL in ArrDr)
//{
// Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"];
//}
SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString());
dr["LoaiTrungBinh"] = TinhPhanTram(SoLuong, SoSinhVien);
}
// Tỷ lệ yếu
ArrDr = dtXepLoai.Select("MaXepLoai = 'Y'");
if (ArrDr.Length > 0)
{
Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"];
//foreach (DataRow drXL in ArrDr)
//{
// Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"];
//}
SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString());
dr["LoaiYeu"] = TinhPhanTram(SoLuong, SoSinhVien);
}
// Tỷ lệ kém
ArrDr = dtXepLoai.Select("MaXepLoai = 'KM'");
if (ArrDr.Length > 0)
{
Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"];
//foreach (DataRow drXL in ArrDr)
//{
// Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"];
//}
Condition += " OR IDKQHT_XepLoai_1 = 0";
SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString());
dr["LoaiKem"] = TinhPhanTram(SoLuong, SoSinhVien);
}
dtMain.Rows.Add(dr);
#endregion
DataTable dtSub = oBKQHT_DiemThanhPhan.CreateTableReportSub_CDCNKT(dtSinhVien, dtThanhPhan, ColStart, IDKQHT_ThanhPhanTBHS);
frmReport frm = new frmReport(dtMain, dtSub, "rBangKetQuaHocTap", "rBangKetQuaHocTapSub", new string[] { "SubReport1" });
frm.Show();
}
public void Delete(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
oDKQHT_XepLoaiMonHoc.Delete(pKQHT_XepLoaiMonHocInfo);
mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages;
mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber;
}
public DataTable Get(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo)
{
return(oDKQHT_XepLoaiMonHoc.Get(pKQHT_XepLoaiMonHocInfo));
}
