public DataTable Get(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_ThamSoQuyCheID", SqlDbType.Int, pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID)); return(RunProcedureGet("sp_KQHT_ThamSoQuyChe_Get", colParam)); }
public void Delete(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_ThamSoQuyCheID", SqlDbType.Int, pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID)); RunProcedure("sp_KQHT_ThamSoQuyChe_Delete", colParam); }
public void ToDataRow(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo, ref DataRow dr) { dr[pKQHT_ThamSoQuyCheInfo.strKQHT_ThamSoQuyCheID] = pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID; dr[pKQHT_ThamSoQuyCheInfo.strMaThamSo] = pKQHT_ThamSoQuyCheInfo.MaThamSo; dr[pKQHT_ThamSoQuyCheInfo.strTenThamSo] = pKQHT_ThamSoQuyCheInfo.TenThamSo; dr[pKQHT_ThamSoQuyCheInfo.strGiaTriMacDinh] = pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh; dr[pKQHT_ThamSoQuyCheInfo.strKieuTruong] = pKQHT_ThamSoQuyCheInfo.KieuTruong; }
public void ToInfo(ref KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo, DataRow dr) { pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID = int.Parse(dr[pKQHT_ThamSoQuyCheInfo.strKQHT_ThamSoQuyCheID].ToString()); pKQHT_ThamSoQuyCheInfo.MaThamSo = dr[pKQHT_ThamSoQuyCheInfo.strMaThamSo].ToString(); pKQHT_ThamSoQuyCheInfo.TenThamSo = dr[pKQHT_ThamSoQuyCheInfo.strTenThamSo].ToString(); pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh = dr[pKQHT_ThamSoQuyCheInfo.strGiaTriMacDinh].ToString(); pKQHT_ThamSoQuyCheInfo.KieuTruong = dr[pKQHT_ThamSoQuyCheInfo.strKieuTruong].ToString(); }
public int Add(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { int ID = 0; ID = oDKQHT_ThamSoQuyChe.Add(pKQHT_ThamSoQuyCheInfo); mErrorMessage = oDKQHT_ThamSoQuyChe.ErrorMessages; mErrorNumber = oDKQHT_ThamSoQuyChe.ErrorNumber; return(ID); }
public void Update(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@MaThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.MaThamSo)); colParam.Add(CreateParam("@TenThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.TenThamSo)); colParam.Add(CreateParam("@GiaTriMacDinh", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh)); colParam.Add(CreateParam("@KieuTruong", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.KieuTruong)); colParam.Add(CreateParam("@KQHT_ThamSoQuyCheID", SqlDbType.Int, pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID)); RunProcedure("sp_KQHT_ThamSoQuyChe_Update", colParam); }
public int Add(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@MaThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.MaThamSo)); colParam.Add(CreateParam("@TenThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.TenThamSo)); colParam.Add(CreateParam("@GiaTriMacDinh", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh)); colParam.Add(CreateParam("@KieuTruong", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.KieuTruong)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_ThamSoQuyChe_Add", colParam)); }
public List <KQHT_ThamSoQuyCheInfo> GetList(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { List <KQHT_ThamSoQuyCheInfo> oKQHT_ThamSoQuyCheInfoList = new List <KQHT_ThamSoQuyCheInfo>(); DataTable dtb = Get(pKQHT_ThamSoQuyCheInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_ThamSoQuyCheInfo = new KQHT_ThamSoQuyCheInfo(); oKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID = int.Parse(dtb.Rows[i]["KQHT_ThamSoQuyCheID"].ToString()); oKQHT_ThamSoQuyCheInfo.MaThamSo = dtb.Rows[i]["MaThamSo"].ToString(); oKQHT_ThamSoQuyCheInfo.TenThamSo = dtb.Rows[i]["TenThamSo"].ToString(); oKQHT_ThamSoQuyCheInfo.GiaTriMacDinh = dtb.Rows[i]["GiaTriMacDinh"].ToString(); oKQHT_ThamSoQuyCheInfo.KieuTruong = dtb.Rows[i]["KieuTruong"].ToString(); oKQHT_ThamSoQuyCheInfoList.Add(oKQHT_ThamSoQuyCheInfo); } } return(oKQHT_ThamSoQuyCheInfoList); }
public void Delete(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { oDKQHT_ThamSoQuyChe.Delete(pKQHT_ThamSoQuyCheInfo); mErrorMessage = oDKQHT_ThamSoQuyChe.ErrorMessages; mErrorNumber = oDKQHT_ThamSoQuyChe.ErrorNumber; }
public DataTable Get(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo) { return(oDKQHT_ThamSoQuyChe.Get(pKQHT_ThamSoQuyCheInfo)); }
public frmThamSoQuyChe() { InitializeComponent(); pKQHT_ThamSoQuyCheInfo = new KQHT_ThamSoQuyCheInfo(); oBKQHT_ThamSoQuyChe = new cBKQHT_ThamSoQuyChe(); }