public int AddNew(DonViInfo donViInfo) { string strSql = "INSERT INTO Units VALUES(@UnitID, @Name, @Note)"; int nRow = 0; try { nRow = dB.ExecuteNonQuery(CommandType.Text, strSql, new SqlParameter { ParameterName = "@UnitID", Value = donViInfo.UnitID }, new SqlParameter { ParameterName = "@Name", Value = donViInfo.Name }, new SqlParameter { ParameterName = "@Note", Value = donViInfo.Note } ); } catch (SqlException ex) { throw ex; } return(nRow); }
public int Update(DonViInfo donViInfo) { string strSQL = "UpdateUnits"; int nRow = 0; try { nRow = dB.ExecuteNonQuery(CommandType.StoredProcedure, strSQL, new SqlParameter { ParameterName = "@UnitID", Value = donViInfo.UnitID }, new SqlParameter { ParameterName = "@Name", Value = donViInfo.Name }, new SqlParameter { ParameterName = "@Note", Value = donViInfo.Note } ); } catch (SqlException ex) { throw ex; } return(nRow); }
public DonViInfo LoadInfo(int id) { string sqlStr = string.Format("SELECT * FROM Units WHERE UnitID = {0}", id); DataTable dt = dB.getData(sqlStr); DonViInfo donViInfo = new DonViInfo(); donViInfo.UnitID = int.Parse(dt.Rows[0]["UnitID"].ToString()); donViInfo.Name = dt.Rows[0]["Name"].ToString(); donViInfo.Note = dt.Rows[0]["Note"].ToString(); return(donViInfo); }
public static IList <DonViInfo> LayDsDonVi(String phong) { DonViData m_DVData = new DonViData(); DataTable m_DV = m_DVData.LayDSTheoLoaiDonVi(phong); IList <DonViInfo> dS = new List <DonViInfo>(); foreach (DataRow Row in m_DV.Rows) { DonViInfo dv = new DonViInfo(); dv.MaDonVi = Convert.ToString(Row["MaDonVi"]); dv.TenDonVi = Convert.ToString(Row["TenDonVi"]); dS.Add(dv); } return(dS); }
public static IList <NhanVienInfo> LayDsLuongNhanVien(String dt) { NhanVienData m_NVData = new NhanVienData(); //DataTable m_DT = m_NVData.LayDsNhanVienForReport(); DataTable m_DT = m_NVData.LayDSNV(dt); IList <NhanVienInfo> dS = new List <NhanVienInfo>(); foreach (DataRow Row in m_DT.Rows) { NhanVienInfo nv = new NhanVienInfo(); ChucVuInfo cv = new ChucVuInfo(); cv.MaChucVu = Convert.ToString(Row["MaChucVu"]); cv.TenChucVu = Convert.ToString(Row["TenChucVu"]); DonViInfo dv = new DonViInfo(); dv.MaDonVi = Convert.ToString(Row["MaDonVi"]); dv.TenDonVi = Convert.ToString(Row["TenDonVi"]); GioiTinhInfo gt = new GioiTinhInfo(); gt.MaGioiTinh = Convert.ToString(Row["MaGioiTinh"]); gt.TenGioiTinh = Convert.ToString(Row["TenGioiTinh"]); nv.MaNhanVien = Convert.ToString(Row["MaNhanVien"]); nv.HoTen = Convert.ToString(Row["HoTenNhanVien"]); nv.GT = gt; nv.ChucVu = cv; nv.DonVi = dv; nv.QueQuan = Convert.ToString(Row["QueQuan"]); dS.Add(nv); } return(dS); }
public int Update(DonViInfo donViInfo) { return(donViDAO.Update(donViInfo)); }
public int AddNew(DonViInfo donViInfo) { return(donViDAO.AddNew(donViInfo)); }