public void ToInfo(ref KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo, DataRow dr)
{
pKQHT_CongThucDiemToanKhoaInfo.KQHT_CongThucDiemToanKhoaID = int.Parse(dr[pKQHT_CongThucDiemToanKhoaInfo.strKQHT_CongThucDiemToanKhoaID].ToString());
pKQHT_CongThucDiemToanKhoaInfo.TenCongThucDiem = dr[pKQHT_CongThucDiemToanKhoaInfo.strTenCongThucDiem].ToString();
pKQHT_CongThucDiemToanKhoaInfo.CongThuc = dr[pKQHT_CongThucDiemToanKhoaInfo.strCongThuc].ToString();
pKQHT_CongThucDiemToanKhoaInfo.GhChu = dr[pKQHT_CongThucDiemToanKhoaInfo.strGhChu].ToString();
}
public frmCongThucDiemToanKhoa()
{
InitializeComponent();
pKQHT_CongThucDiemToanKhoaInfo = new KQHT_CongThucDiemToanKhoaInfo();
oBKQHT_CongThucDiemToanKhoa = new cBKQHT_CongThucDiemToanKhoa();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
}
public void ToDataRow(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo, ref DataRow dr)
{
dr[pKQHT_CongThucDiemToanKhoaInfo.strKQHT_CongThucDiemToanKhoaID] = pKQHT_CongThucDiemToanKhoaInfo.KQHT_CongThucDiemToanKhoaID;
dr[pKQHT_CongThucDiemToanKhoaInfo.strTenCongThucDiem] = pKQHT_CongThucDiemToanKhoaInfo.TenCongThucDiem;
dr[pKQHT_CongThucDiemToanKhoaInfo.strCongThuc] = pKQHT_CongThucDiemToanKhoaInfo.CongThuc;
dr[pKQHT_CongThucDiemToanKhoaInfo.strGhChu] = pKQHT_CongThucDiemToanKhoaInfo.GhChu;
}
public void Delete(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_CongThucDiemToanKhoaID", SqlDbType.Int, pKQHT_CongThucDiemToanKhoaInfo.KQHT_CongThucDiemToanKhoaID));
RunProcedure("sp_KQHT_CongThucDiemToanKhoa_Delete", colParam);
}
public DataTable Get(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_CongThucDiemToanKhoaID", SqlDbType.Int, pKQHT_CongThucDiemToanKhoaInfo.KQHT_CongThucDiemToanKhoaID));
return(RunProcedureGet("sp_KQHT_CongThucDiemToanKhoa_Get", colParam));
}
public int Add(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
int ID = 0;
ID = oDKQHT_CongThucDiemToanKhoa.Add(pKQHT_CongThucDiemToanKhoaInfo);
mErrorMessage = oDKQHT_CongThucDiemToanKhoa.ErrorMessages;
mErrorNumber = oDKQHT_CongThucDiemToanKhoa.ErrorNumber;
return(ID);
}
public void Update(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenCongThucDiem", SqlDbType.NVarChar, pKQHT_CongThucDiemToanKhoaInfo.TenCongThucDiem));
colParam.Add(CreateParam("@CongThuc", SqlDbType.NVarChar, pKQHT_CongThucDiemToanKhoaInfo.CongThuc));
colParam.Add(CreateParam("@GhChu", SqlDbType.NVarChar, pKQHT_CongThucDiemToanKhoaInfo.GhChu));
colParam.Add(CreateParam("@KQHT_CongThucDiemToanKhoaID", SqlDbType.Int, pKQHT_CongThucDiemToanKhoaInfo.KQHT_CongThucDiemToanKhoaID));
RunProcedure("sp_KQHT_CongThucDiemToanKhoa_Update", colParam);
}
public int Add(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenCongThucDiem", SqlDbType.NVarChar, pKQHT_CongThucDiemToanKhoaInfo.TenCongThucDiem));
colParam.Add(CreateParam("@CongThuc", SqlDbType.NVarChar, pKQHT_CongThucDiemToanKhoaInfo.CongThuc));
colParam.Add(CreateParam("@GhChu", SqlDbType.NVarChar, pKQHT_CongThucDiemToanKhoaInfo.GhChu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_CongThucDiemToanKhoa_Add", colParam));
}
public List <KQHT_CongThucDiemToanKhoaInfo> GetList(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
List <KQHT_CongThucDiemToanKhoaInfo> oKQHT_CongThucDiemToanKhoaInfoList = new List <KQHT_CongThucDiemToanKhoaInfo>();
DataTable dtb = Get(pKQHT_CongThucDiemToanKhoaInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_CongThucDiemToanKhoaInfo = new KQHT_CongThucDiemToanKhoaInfo();
oKQHT_CongThucDiemToanKhoaInfo.KQHT_CongThucDiemToanKhoaID = int.Parse(dtb.Rows[i]["KQHT_CongThucDiemToanKhoaID"].ToString());
oKQHT_CongThucDiemToanKhoaInfo.TenCongThucDiem = dtb.Rows[i]["TenCongThucDiem"].ToString();
oKQHT_CongThucDiemToanKhoaInfo.CongThuc = dtb.Rows[i]["CongThuc"].ToString();
oKQHT_CongThucDiemToanKhoaInfo.GhChu = dtb.Rows[i]["GhChu"].ToString();
oKQHT_CongThucDiemToanKhoaInfoList.Add(oKQHT_CongThucDiemToanKhoaInfo);
}
}
return(oKQHT_CongThucDiemToanKhoaInfoList);
}
public void Delete(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
oDKQHT_CongThucDiemToanKhoa.Delete(pKQHT_CongThucDiemToanKhoaInfo);
mErrorMessage = oDKQHT_CongThucDiemToanKhoa.ErrorMessages;
mErrorNumber = oDKQHT_CongThucDiemToanKhoa.ErrorNumber;
}
public DataTable Get(KQHT_CongThucDiemToanKhoaInfo pKQHT_CongThucDiemToanKhoaInfo)
{
return(oDKQHT_CongThucDiemToanKhoa.Get(pKQHT_CongThucDiemToanKhoaInfo));
}
