public DataTable Get(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <sp_KQHT_DiemDanh_GetResult>(client.cDKQHT_DiemDanh_Get(GlobalVar.MaXacThuc, pKQHT_DiemDanhInfo))); } }
public void ToInfo(ref KQHT_DiemDanhInfo pKQHT_DiemDanhInfo, DataRow dr) { pKQHT_DiemDanhInfo.KQHT_DiemDanhID = int.Parse(dr[pKQHT_DiemDanhInfo.strKQHT_DiemDanhID].ToString()); pKQHT_DiemDanhInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DiemDanhInfo.strIDSV_SinhVien].ToString()); pKQHT_DiemDanhInfo.IDXL_MonHocTrongKy = int.Parse(dr[pKQHT_DiemDanhInfo.strIDXL_MonHocTrongKy].ToString()); pKQHT_DiemDanhInfo.CoLyDo = int.Parse(dr[pKQHT_DiemDanhInfo.strCoLyDo].ToString()); pKQHT_DiemDanhInfo.KhongLyDo = int.Parse(dr[pKQHT_DiemDanhInfo.strKhongLyDo].ToString()); }
public void Delete(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DiemDanhID", SqlDbType.Int, pKQHT_DiemDanhInfo.KQHT_DiemDanhID)); RunProcedure("sp_KQHT_DiemDanh_Delete", colParam); }
public void ToDataRow(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo, ref DataRow dr) { dr[pKQHT_DiemDanhInfo.strKQHT_DiemDanhID] = pKQHT_DiemDanhInfo.KQHT_DiemDanhID; dr[pKQHT_DiemDanhInfo.strIDSV_SinhVien] = pKQHT_DiemDanhInfo.IDSV_SinhVien; dr[pKQHT_DiemDanhInfo.strIDXL_MonHocTrongKy] = pKQHT_DiemDanhInfo.IDXL_MonHocTrongKy; dr[pKQHT_DiemDanhInfo.strCoLyDo] = pKQHT_DiemDanhInfo.CoLyDo; dr[pKQHT_DiemDanhInfo.strKhongLyDo] = pKQHT_DiemDanhInfo.KhongLyDo; }
public DataTable Get(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DiemDanhID", SqlDbType.Int, pKQHT_DiemDanhInfo.KQHT_DiemDanhID)); return RunProcedureGet("sp_KQHT_DiemDanh_Get", colParam); }
public void Delete(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { var client = new UnimOsServiceClient(); client.cDKQHT_DiemDanh_Delete(GlobalVar.MaXacThuc, pKQHT_DiemDanhInfo); client.Close(); mErrorMessage = oDKQHT_DiemDanh.ErrorMessages; mErrorNumber = oDKQHT_DiemDanh.ErrorNumber; }
public int Add(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { int ID = 0; ID = oDKQHT_DiemDanh.Add(pKQHT_DiemDanhInfo); mErrorMessage = oDKQHT_DiemDanh.ErrorMessages; mErrorNumber = oDKQHT_DiemDanh.ErrorNumber; return(ID); }
public frmTheoDoiMonHoc() { InitializeComponent(); oBDM_Lop = new cBDM_Lop(); oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy(); oBKQHT_DiemDanh = new cBKQHT_DiemDanh(); pKQHT_DiemDanhInfo = new KQHT_DiemDanhInfo(); oBKQHT_DiemDanh_ChiTiet = new cBKQHT_DiemDanh_ChiTiet(); pKQHT_DiemDanh_ChiTietInfo = new KQHT_DiemDanh_ChiTietInfo(); }
public int Add(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { int ID = 0; var client = new UnimOsServiceClient(); ID = client.cDKQHT_DiemDanh_Add(GlobalVar.MaXacThuc, pKQHT_DiemDanhInfo); client.Close(); mErrorMessage = oDKQHT_DiemDanh.ErrorMessages; mErrorNumber = oDKQHT_DiemDanh.ErrorNumber; return(ID); }
public void Update(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemDanhInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DiemDanhInfo.IDXL_MonHocTrongKy)); colParam.Add(CreateParam("@CoLyDo", SqlDbType.Int, pKQHT_DiemDanhInfo.CoLyDo)); colParam.Add(CreateParam("@KhongLyDo", SqlDbType.Int, pKQHT_DiemDanhInfo.KhongLyDo)); colParam.Add(CreateParam("@KQHT_DiemDanhID", SqlDbType.Int, pKQHT_DiemDanhInfo.KQHT_DiemDanhID)); RunProcedure("sp_KQHT_DiemDanh_Update", colParam); }
public int Add(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemDanhInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DiemDanhInfo.IDXL_MonHocTrongKy)); colParam.Add(CreateParam("@CoLyDo", SqlDbType.Int, pKQHT_DiemDanhInfo.CoLyDo)); colParam.Add(CreateParam("@KhongLyDo", SqlDbType.Int, pKQHT_DiemDanhInfo.KhongLyDo)); colParam.Add(CreateParam("@DiemLan", SqlDbType.Int, pKQHT_DiemDanhInfo.DiemLan)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return (int)RunProcedureOut("sp_KQHT_DiemDanh_Add", colParam); }
public List <KQHT_DiemDanhInfo> GetList(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { List <KQHT_DiemDanhInfo> oKQHT_DiemDanhInfoList = new List <KQHT_DiemDanhInfo>(); DataTable dtb = Get(pKQHT_DiemDanhInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_DiemDanhInfo = new KQHT_DiemDanhInfo(); oKQHT_DiemDanhInfo.KQHT_DiemDanhID = int.Parse(dtb.Rows[i]["KQHT_DiemDanhID"].ToString()); oKQHT_DiemDanhInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString()); oKQHT_DiemDanhInfo.IDXL_MonHocTrongKy = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKy"].ToString()); oKQHT_DiemDanhInfo.CoLyDo = int.Parse(dtb.Rows[i]["CoLyDo"].ToString()); oKQHT_DiemDanhInfo.KhongLyDo = int.Parse(dtb.Rows[i]["KhongLyDo"].ToString()); oKQHT_DiemDanhInfoList.Add(oKQHT_DiemDanhInfo); } } return(oKQHT_DiemDanhInfoList); }
public void Delete(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { oDKQHT_DiemDanh.Delete(pKQHT_DiemDanhInfo); mErrorMessage = oDKQHT_DiemDanh.ErrorMessages; mErrorNumber = oDKQHT_DiemDanh.ErrorNumber; }
public DataTable Get(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo) { return(oDKQHT_DiemDanh.Get(pKQHT_DiemDanhInfo)); }