public void Delete(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_LinhVucCongTacID", SqlDbType.Int, pNS_LinhVucCongTacInfo.NS_LinhVucCongTacID)); RunProcedure("sp_NS_LinhVucCongTac_Delete", colParam); }
public DataTable Get(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_LinhVucCongTacID", SqlDbType.Int, pNS_LinhVucCongTacInfo.NS_LinhVucCongTacID)); return(RunProcedureGet("sp_NS_LinhVucCongTac_Get", colParam)); }
public int Add(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { int ID = 0; ID = oDNS_LinhVucCongTac.Add(pNS_LinhVucCongTacInfo); mErrorMessage = oDNS_LinhVucCongTac.ErrorMessages; mErrorNumber = oDNS_LinhVucCongTac.ErrorNumber; return(ID); }
public void Update(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@STT", SqlDbType.Int, pNS_LinhVucCongTacInfo.STT)); colParam.Add(CreateParam("@TenLinhVuc", SqlDbType.NVarChar, pNS_LinhVucCongTacInfo.TenLinhVuc)); colParam.Add(CreateParam("@NS_LinhVucCongTacID", SqlDbType.Int, pNS_LinhVucCongTacInfo.NS_LinhVucCongTacID)); RunProcedure("sp_NS_LinhVucCongTac_Update", colParam); }
public int Add(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@STT", SqlDbType.Int, pNS_LinhVucCongTacInfo.STT)); colParam.Add(CreateParam("@TenLinhVuc", SqlDbType.NVarChar, pNS_LinhVucCongTacInfo.TenLinhVuc)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_NS_LinhVucCongTac_Add", colParam)); }
public List <NS_LinhVucCongTacInfo> GetList(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { List <NS_LinhVucCongTacInfo> oNS_LinhVucCongTacInfoList = new List <NS_LinhVucCongTacInfo>(); DataTable dtb = Get(pNS_LinhVucCongTacInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { pNS_LinhVucCongTacInfo = new NS_LinhVucCongTacInfo(); pNS_LinhVucCongTacInfo.NS_LinhVucCongTacID = int.Parse(dtb.Rows[i][pNS_LinhVucCongTacInfo.strNS_LinhVucCongTacID].ToString()); pNS_LinhVucCongTacInfo.STT = int.Parse(dtb.Rows[i][pNS_LinhVucCongTacInfo.strSTT].ToString()); pNS_LinhVucCongTacInfo.TenLinhVuc = dtb.Rows[i][pNS_LinhVucCongTacInfo.strTenLinhVuc].ToString(); oNS_LinhVucCongTacInfoList.Add(pNS_LinhVucCongTacInfo); } } return(oNS_LinhVucCongTacInfoList); }
public void ToInfo(ref NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo, DataRow dr) { pNS_LinhVucCongTacInfo.NS_LinhVucCongTacID = int.Parse(dr[pNS_LinhVucCongTacInfo.strNS_LinhVucCongTacID].ToString()); pNS_LinhVucCongTacInfo.STT = int.Parse(dr[pNS_LinhVucCongTacInfo.strSTT].ToString()); pNS_LinhVucCongTacInfo.TenLinhVuc = dr[pNS_LinhVucCongTacInfo.strTenLinhVuc].ToString(); }
public void ToDataRow(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo, ref DataRow dr) { dr[pNS_LinhVucCongTacInfo.strNS_LinhVucCongTacID] = pNS_LinhVucCongTacInfo.NS_LinhVucCongTacID; dr[pNS_LinhVucCongTacInfo.strSTT] = pNS_LinhVucCongTacInfo.STT; dr[pNS_LinhVucCongTacInfo.strTenLinhVuc] = pNS_LinhVucCongTacInfo.TenLinhVuc; }
public void Delete(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { oDNS_LinhVucCongTac.Delete(pNS_LinhVucCongTacInfo); mErrorMessage = oDNS_LinhVucCongTac.ErrorMessages; mErrorNumber = oDNS_LinhVucCongTac.ErrorNumber; }
public DataTable Get(NS_LinhVucCongTacInfo pNS_LinhVucCongTacInfo) { return(oDNS_LinhVucCongTac.Get(pNS_LinhVucCongTacInfo)); }