public void ToInfo(ref NS_NgachCongChucInfo pNS_NgachCongChucInfo, DataRow dr) { pNS_NgachCongChucInfo.NS_NgachCongChucID = int.Parse(dr[pNS_NgachCongChucInfo.strNS_NgachCongChucID].ToString()); pNS_NgachCongChucInfo.MaNgachCongChuc = dr[pNS_NgachCongChucInfo.strMaNgachCongChuc].ToString(); pNS_NgachCongChucInfo.TenNgachCongChuc = dr[pNS_NgachCongChucInfo.strTenNgachCongChuc].ToString(); pNS_NgachCongChucInfo.IDNS_NhomNgach = int.Parse("0" + dr[pNS_NgachCongChucInfo.strIDNS_NhomNgach]); }
public void ToDataRow(NS_NgachCongChucInfo pNS_NgachCongChucInfo, ref DataRow dr) { dr[pNS_NgachCongChucInfo.strNS_NgachCongChucID] = pNS_NgachCongChucInfo.NS_NgachCongChucID; dr[pNS_NgachCongChucInfo.strMaNgachCongChuc] = pNS_NgachCongChucInfo.MaNgachCongChuc; dr[pNS_NgachCongChucInfo.strTenNgachCongChuc] = pNS_NgachCongChucInfo.TenNgachCongChuc; dr[pNS_NgachCongChucInfo.strIDNS_NhomNgach] = pNS_NgachCongChucInfo.IDNS_NhomNgach; }
public void Delete(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_NgachCongChucID", SqlDbType.Int, pNS_NgachCongChucInfo.NS_NgachCongChucID)); RunProcedure("sp_NS_NgachCongChuc_Delete", colParam); }
public DataTable Get(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NS_NgachCongChucID", SqlDbType.Int, pNS_NgachCongChucInfo.NS_NgachCongChucID)); return(RunProcedureGet("sp_NS_NgachCongChuc_Get", colParam)); }
public frmDM_NgachCongChuc(frmLuong _frmLuong, frmNangBacChuyenNgach _frmNangBacChuyenNgach) { InitializeComponent(); oBNS_NgachCongChuc = new cBNS_NgachCongChuc(); pNS_NgachCongChucInfo = new NS_NgachCongChucInfo(); SetControl(false); ofrmLuong = _frmLuong; ofrmNangBacChuyenNgach = _frmNangBacChuyenNgach; }
public int Add(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { int ID = 0; ID = oDNS_NgachCongChuc.Add(pNS_NgachCongChucInfo); mErrorMessage = oDNS_NgachCongChuc.ErrorMessages; mErrorNumber = oDNS_NgachCongChuc.ErrorNumber; return(ID); }
public void Update(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@MaNgachCongChuc", SqlDbType.NVarChar, pNS_NgachCongChucInfo.MaNgachCongChuc)); colParam.Add(CreateParam("@TenNgachCongChuc", SqlDbType.NVarChar, pNS_NgachCongChucInfo.TenNgachCongChuc)); colParam.Add(CreateParam("@IDNS_NhomNgach", SqlDbType.Int, pNS_NgachCongChucInfo.IDNS_NhomNgach)); colParam.Add(CreateParam("@NS_NgachCongChucID", SqlDbType.Int, pNS_NgachCongChucInfo.NS_NgachCongChucID)); RunProcedure("sp_NS_NgachCongChuc_Update", colParam); }
public int Add(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@MaNgachCongChuc", SqlDbType.NVarChar, pNS_NgachCongChucInfo.MaNgachCongChuc)); colParam.Add(CreateParam("@TenNgachCongChuc", SqlDbType.NVarChar, pNS_NgachCongChucInfo.TenNgachCongChuc)); colParam.Add(CreateParam("@IDNS_NhomNgach", SqlDbType.Int, pNS_NgachCongChucInfo.IDNS_NhomNgach)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_NS_NgachCongChuc_Add", colParam)); }
public List <NS_NgachCongChucInfo> GetList(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { List <NS_NgachCongChucInfo> oNS_NgachCongChucInfoList = new List <NS_NgachCongChucInfo>(); DataTable dtb = Get(pNS_NgachCongChucInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oNS_NgachCongChucInfo = new NS_NgachCongChucInfo(); oNS_NgachCongChucInfo.NS_NgachCongChucID = int.Parse(dtb.Rows[i]["NS_NgachCongChucID"].ToString()); oNS_NgachCongChucInfo.MaNgachCongChuc = dtb.Rows[i]["MaNgachCongChuc"].ToString(); oNS_NgachCongChucInfo.TenNgachCongChuc = dtb.Rows[i]["TenNgachCongChuc"].ToString(); oNS_NgachCongChucInfo.IDNS_NhomNgach = int.Parse(dtb.Rows[i]["IDNS_NhomNgach"].ToString()); oNS_NgachCongChucInfoList.Add(oNS_NgachCongChucInfo); } } return(oNS_NgachCongChucInfoList); }
public void Delete(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { oDNS_NgachCongChuc.Delete(pNS_NgachCongChucInfo); mErrorMessage = oDNS_NgachCongChuc.ErrorMessages; mErrorNumber = oDNS_NgachCongChuc.ErrorNumber; }
public DataTable Get(NS_NgachCongChucInfo pNS_NgachCongChucInfo) { return(oDNS_NgachCongChuc.Get(pNS_NgachCongChucInfo)); }