public List <KQHT_ChoNhapLaiDiemInfo> GetList(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
List <KQHT_ChoNhapLaiDiemInfo> oKQHT_ChoNhapLaiDiemInfoList = new List <KQHT_ChoNhapLaiDiemInfo>();
DataTable dtb = Get(pKQHT_ChoNhapLaiDiemInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
pKQHT_ChoNhapLaiDiemInfo = new KQHT_ChoNhapLaiDiemInfo();
pKQHT_ChoNhapLaiDiemInfo.KQHT_ChoNhapLaiDiemID = int.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strKQHT_ChoNhapLaiDiemID].ToString());
pKQHT_ChoNhapLaiDiemInfo.IDKQHT_DaChuyenDiem = int.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strIDKQHT_DaChuyenDiem].ToString());
pKQHT_ChoNhapLaiDiemInfo.IDHT_User = int.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strIDHT_User].ToString());
pKQHT_ChoNhapLaiDiemInfo.LanChoNhapLai = int.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strLanChoNhapLai].ToString());
pKQHT_ChoNhapLaiDiemInfo.NgayChoNhapLai = DateTime.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strNgayChoNhapLai].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L1 = bool.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strDiemThanhPhan_L1].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThi_L1 = bool.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strDiemThi_L1].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L2 = bool.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strDiemThanhPhan_L2].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThi_L2 = bool.Parse(dtb.Rows[i][pKQHT_ChoNhapLaiDiemInfo.strDiemThi_L2].ToString());
oKQHT_ChoNhapLaiDiemInfoList.Add(pKQHT_ChoNhapLaiDiemInfo);
}
}
return(oKQHT_ChoNhapLaiDiemInfoList);
}
public void Delete(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_ChoNhapLaiDiemID", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.KQHT_ChoNhapLaiDiemID));
RunProcedure("sp_KQHT_ChoNhapLaiDiem_Delete", colParam);
}
public DataTable Get(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_ChoNhapLaiDiemID", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.KQHT_ChoNhapLaiDiemID));
return(RunProcedureGet("sp_KQHT_ChoNhapLaiDiem_Get", colParam));
}
public int Add(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
int ID = 0;
ID = oDKQHT_ChoNhapLaiDiem.Add(pKQHT_ChoNhapLaiDiemInfo);
mErrorMessage = oDKQHT_ChoNhapLaiDiem.ErrorMessages;
mErrorNumber = oDKQHT_ChoNhapLaiDiem.ErrorNumber;
return(ID);
}
public void ToDataRow(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo, ref DataRow dr)
{
dr[pKQHT_ChoNhapLaiDiemInfo.strKQHT_ChoNhapLaiDiemID] = pKQHT_ChoNhapLaiDiemInfo.KQHT_ChoNhapLaiDiemID;
dr[pKQHT_ChoNhapLaiDiemInfo.strIDKQHT_DaChuyenDiem] = pKQHT_ChoNhapLaiDiemInfo.IDKQHT_DaChuyenDiem;
dr[pKQHT_ChoNhapLaiDiemInfo.strIDHT_User] = pKQHT_ChoNhapLaiDiemInfo.IDHT_User;
dr[pKQHT_ChoNhapLaiDiemInfo.strLanChoNhapLai] = pKQHT_ChoNhapLaiDiemInfo.LanChoNhapLai;
dr[pKQHT_ChoNhapLaiDiemInfo.strNgayChoNhapLai] = pKQHT_ChoNhapLaiDiemInfo.NgayChoNhapLai;
dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThanhPhan_L1] = pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L1;
dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThi_L1] = pKQHT_ChoNhapLaiDiemInfo.DiemThi_L1;
dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThanhPhan_L2] = pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L2;
dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThi_L2] = pKQHT_ChoNhapLaiDiemInfo.DiemThi_L2;
}
public void ToInfo(ref KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo, DataRow dr)
{
pKQHT_ChoNhapLaiDiemInfo.KQHT_ChoNhapLaiDiemID = int.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strKQHT_ChoNhapLaiDiemID].ToString());
pKQHT_ChoNhapLaiDiemInfo.IDKQHT_DaChuyenDiem = int.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strIDKQHT_DaChuyenDiem].ToString());
pKQHT_ChoNhapLaiDiemInfo.IDHT_User = int.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strIDHT_User].ToString());
pKQHT_ChoNhapLaiDiemInfo.LanChoNhapLai = int.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strLanChoNhapLai].ToString());
pKQHT_ChoNhapLaiDiemInfo.NgayChoNhapLai = DateTime.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strNgayChoNhapLai].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L1 = bool.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThanhPhan_L1].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThi_L1 = bool.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThi_L1].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L2 = bool.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThanhPhan_L2].ToString());
pKQHT_ChoNhapLaiDiemInfo.DiemThi_L2 = bool.Parse(dr[pKQHT_ChoNhapLaiDiemInfo.strDiemThi_L2].ToString());
}
public void Update(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_DaChuyenDiem", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.IDKQHT_DaChuyenDiem));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.IDHT_User));
colParam.Add(CreateParam("@LanChoNhapLai", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.LanChoNhapLai));
colParam.Add(CreateParam("@NgayChoNhapLai", SqlDbType.DateTime, pKQHT_ChoNhapLaiDiemInfo.NgayChoNhapLai));
colParam.Add(CreateParam("@DiemThanhPhan_L1", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L1));
colParam.Add(CreateParam("@DiemThi_L1", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThi_L1));
colParam.Add(CreateParam("@DiemThanhPhan_L2", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L2));
colParam.Add(CreateParam("@DiemThi_L2", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThi_L2));
colParam.Add(CreateParam("@KQHT_ChoNhapLaiDiemID", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.KQHT_ChoNhapLaiDiemID));
RunProcedure("sp_KQHT_ChoNhapLaiDiem_Update", colParam);
}
public int Add(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_DaChuyenDiem", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.IDKQHT_DaChuyenDiem));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.IDHT_User));
colParam.Add(CreateParam("@LanChoNhapLai", SqlDbType.Int, pKQHT_ChoNhapLaiDiemInfo.LanChoNhapLai));
colParam.Add(CreateParam("@NgayChoNhapLai", SqlDbType.DateTime, pKQHT_ChoNhapLaiDiemInfo.NgayChoNhapLai));
colParam.Add(CreateParam("@DiemThanhPhan_L1", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L1));
colParam.Add(CreateParam("@DiemThi_L1", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThi_L1));
colParam.Add(CreateParam("@DiemThanhPhan_L2", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThanhPhan_L2));
colParam.Add(CreateParam("@DiemThi_L2", SqlDbType.Bit, pKQHT_ChoNhapLaiDiemInfo.DiemThi_L2));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_ChoNhapLaiDiem_Add", colParam));
}
public void Delete(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
oDKQHT_ChoNhapLaiDiem.Delete(pKQHT_ChoNhapLaiDiemInfo);
mErrorMessage = oDKQHT_ChoNhapLaiDiem.ErrorMessages;
mErrorNumber = oDKQHT_ChoNhapLaiDiem.ErrorNumber;
}
public DataTable Get(KQHT_ChoNhapLaiDiemInfo pKQHT_ChoNhapLaiDiemInfo)
{
return(oDKQHT_ChoNhapLaiDiem.Get(pKQHT_ChoNhapLaiDiemInfo));
}
