//public void Delete(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDKQHT_MonThiTotNghiep_Lop_Delete(GlobalVar.MaXacThuc, pKQHT_MonThiTotNghiep_LopInfo);
// client.Close();
// mErrorMessage = oDKQHT_MonThiTotNghiep_Lop.ErrorMessages;
// mErrorNumber = oDKQHT_MonThiTotNghiep_Lop.ErrorNumber;
//}
//public List<KQHT_MonThiTotNghiep_LopInfo> GetList(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
//{
// List<KQHT_MonThiTotNghiep_LopInfo> oKQHT_MonThiTotNghiep_LopInfoList = new List<KQHT_MonThiTotNghiep_LopInfo>();
// DataTable dtb = Get(pKQHT_MonThiTotNghiep_LopInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// oKQHT_MonThiTotNghiep_LopInfo = new KQHT_MonThiTotNghiep_LopInfo();
// oKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID = int.Parse(dtb.Rows[i]["KQHT_MonThiTotNghiep_LopID"].ToString());
// oKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
// oKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
// oKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh = int.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());
// oKQHT_MonThiTotNghiep_LopInfo.TinhDiem = bool.Parse(dtb.Rows[i]["TinhDiem"].ToString());
// oKQHT_MonThiTotNghiep_LopInfoList.Add(oKQHT_MonThiTotNghiep_LopInfo);
// }
// }
// return oKQHT_MonThiTotNghiep_LopInfoList;
//}
//public void ToDataRow(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo, ref DataRow dr)
//{
// dr[pKQHT_MonThiTotNghiep_LopInfo.strKQHT_MonThiTotNghiep_LopID] = pKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID;
// dr[pKQHT_MonThiTotNghiep_LopInfo.strIDDM_Lop] = pKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop;
// dr[pKQHT_MonThiTotNghiep_LopInfo.strIDDM_MonHoc] = pKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc;
// dr[pKQHT_MonThiTotNghiep_LopInfo.strTinhDiem] = pKQHT_MonThiTotNghiep_LopInfo.TinhDiem;
// dr[pKQHT_MonThiTotNghiep_LopInfo.strSoHocTrinh] = pKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh;
//}
public void ToInfo(ref KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo, DataRow dr)
{
pKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID = int.Parse(dr[pKQHT_MonThiTotNghiep_LopInfo.strKQHT_MonThiTotNghiep_LopID].ToString());
pKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop = int.Parse(dr[pKQHT_MonThiTotNghiep_LopInfo.strIDDM_Lop].ToString());
pKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_MonThiTotNghiep_LopInfo.strIDDM_MonHoc].ToString());
pKQHT_MonThiTotNghiep_LopInfo.TinhDiem = bool.Parse(dr[pKQHT_MonThiTotNghiep_LopInfo.strTinhDiem].ToString());
pKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh = int.Parse(dr[pKQHT_MonThiTotNghiep_LopInfo.strSoHocTrinh].ToString());
}
public void Delete(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_MonThiTotNghiep_LopID", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID));
RunProcedure("sp_KQHT_MonThiTotNghiep_Lop_Delete", colParam);
}
public frmLop_MonThiTotNghiep()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
pKQHT_MonThiTotNghiep_LopInfo = new KQHT_MonThiTotNghiep_LopInfo();
}
public void ToDataRow(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo, ref DataRow dr)
{
dr[pKQHT_MonThiTotNghiep_LopInfo.strKQHT_MonThiTotNghiep_LopID] = pKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID;
dr[pKQHT_MonThiTotNghiep_LopInfo.strIDDM_Lop] = pKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop;
dr[pKQHT_MonThiTotNghiep_LopInfo.strIDDM_MonHoc] = pKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc;
dr[pKQHT_MonThiTotNghiep_LopInfo.strTinhDiem] = pKQHT_MonThiTotNghiep_LopInfo.TinhDiem;
dr[pKQHT_MonThiTotNghiep_LopInfo.strSoHocTrinh] = pKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh;
}
public DataTable Get(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_MonThiTotNghiep_LopID", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID));
return(RunProcedureGet("sp_KQHT_MonThiTotNghiep_Lop_Get", colParam));
}
public int Add(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
int ID = 0;
ID = oDKQHT_MonThiTotNghiep_Lop.Add(pKQHT_MonThiTotNghiep_LopInfo);
mErrorMessage = oDKQHT_MonThiTotNghiep_Lop.ErrorMessages;
mErrorNumber = oDKQHT_MonThiTotNghiep_Lop.ErrorNumber;
return(ID);
}
public dlgMonTotNghiep_ApDungLopKhac(DM_LopInfo mpDM_LopInfo, DataTable mdtMon)
{
InitializeComponent();
pDM_LopInfo = new DM_LopInfo();
oBDM_Lop = new cBDM_Lop();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
pKQHT_MonThiTotNghiep_LopInfo = new KQHT_MonThiTotNghiep_LopInfo();
pDM_LopInfo = mpDM_LopInfo;
dtMon = mdtMon;
}
public void Update(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@TinhDiem", SqlDbType.Bit, pKQHT_MonThiTotNghiep_LopInfo.TinhDiem));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Float, pKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@KQHT_MonThiTotNghiep_LopID", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID));
RunProcedure("sp_KQHT_MonThiTotNghiep_Lop_Update", colParam);
}
public int Add(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@TinhDiem", SqlDbType.Bit, pKQHT_MonThiTotNghiep_LopInfo.TinhDiem));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Float, pKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_MonThiTotNghiep_LopInfo.IDDM_NamHoc));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_MonThiTotNghiep_Lop_Add", colParam));
}
public List <KQHT_MonThiTotNghiep_LopInfo> GetList(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
List <KQHT_MonThiTotNghiep_LopInfo> oKQHT_MonThiTotNghiep_LopInfoList = new List <KQHT_MonThiTotNghiep_LopInfo>();
DataTable dtb = Get(pKQHT_MonThiTotNghiep_LopInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_MonThiTotNghiep_LopInfo = new KQHT_MonThiTotNghiep_LopInfo();
oKQHT_MonThiTotNghiep_LopInfo.KQHT_MonThiTotNghiep_LopID = int.Parse(dtb.Rows[i]["KQHT_MonThiTotNghiep_LopID"].ToString());
oKQHT_MonThiTotNghiep_LopInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
oKQHT_MonThiTotNghiep_LopInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_MonThiTotNghiep_LopInfo.SoHocTrinh = int.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());
oKQHT_MonThiTotNghiep_LopInfo.TinhDiem = bool.Parse(dtb.Rows[i]["TinhDiem"].ToString());
oKQHT_MonThiTotNghiep_LopInfoList.Add(oKQHT_MonThiTotNghiep_LopInfo);
}
}
return(oKQHT_MonThiTotNghiep_LopInfoList);
}
public void Delete(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
oDKQHT_MonThiTotNghiep_Lop.Delete(pKQHT_MonThiTotNghiep_LopInfo);
mErrorMessage = oDKQHT_MonThiTotNghiep_Lop.ErrorMessages;
mErrorNumber = oDKQHT_MonThiTotNghiep_Lop.ErrorNumber;
}
public DataTable Get(KQHT_MonThiTotNghiep_LopInfo pKQHT_MonThiTotNghiep_LopInfo)
{
return(oDKQHT_MonThiTotNghiep_Lop.Get(pKQHT_MonThiTotNghiep_LopInfo));
}