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