public Boolean SuaLuongNV(LuongNV tv) { SqlConnection conn = getConnection(); conn.Open(); try { string sqlSua = "DECLARE @dem int select @dem = COUNT(MaNV) FROM BangCongNV WHERE MaNV = @MaNV IF @dem != 0 UPDATE BangCongNV " + "SET Thuong = @Thuong ,KyLuat = @KyLuat ,Thang = @Thang , Nam = @Nam , " + "SoGioLamThem = @SoGioLamThem , SoNgayCong = @SoNgayCong , Luong = @TongLuong WHERE MaNV = @MaNV else raiserror('', 16, 1)"; SqlCommand cmd = new SqlCommand(sqlSua, conn); cmd.Parameters.AddWithValue("MaNV", tv.MaNV); cmd.Parameters.AddWithValue("Thuong", tv.Thuong); cmd.Parameters.AddWithValue("KyLuat", tv.KyLuat); cmd.Parameters.AddWithValue("Thang", tv.Thang); cmd.Parameters.AddWithValue("Nam", tv.Nam); cmd.Parameters.AddWithValue("SoGioLamThem", tv.SoGioLamThem); cmd.Parameters.AddWithValue("SoNgayCong", tv.SoNgayCong); cmd.Parameters.AddWithValue("TongLuong", tv.TongLuong); cmd.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
public Boolean ThemLuongNV(LuongNV tv) { SqlConnection conn = getConnection(); conn.Open(); try { string sqlThem = "INSERT INTO BangCongNV VALUES(@MaPB , @MaNV , @MaLuong , @LCB , @PhuCap , @Thuong , @KyLuat , @Thang ,@Nam ,@SoGioLamThem ,@SoNgayCong ,@TongLuong)"; SqlCommand cmd = new SqlCommand(sqlThem, conn); cmd.Parameters.AddWithValue("MaPB", tv.MaPB); cmd.Parameters.AddWithValue("MaNV", tv.MaNV); cmd.Parameters.AddWithValue("MaLuong", tv.MaLuong); cmd.Parameters.AddWithValue("LCB", tv.LCB); cmd.Parameters.AddWithValue("PhuCap", tv.PhuCap); cmd.Parameters.AddWithValue("Thuong", tv.Thuong); cmd.Parameters.AddWithValue("KyLuat", tv.KyLuat); cmd.Parameters.AddWithValue("Thang", tv.Thang); cmd.Parameters.AddWithValue("Nam", tv.Nam); cmd.Parameters.AddWithValue("SoGioLamThem", tv.SoGioLamThem); cmd.Parameters.AddWithValue("SoNgayCong", tv.SoNgayCong); cmd.Parameters.AddWithValue("TongLuong", tv.TongLuong); cmd.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
public void Edit_ChamCong() { bool t = false; List <LuongNV> luongNVs = LuongNVDAO.Instance.GetLuongs(); foreach (LuongNV data in luongNVs) { for (int i = 0; i < lv_nv.SelectedItems.Count; i++) { if (data.IDChamCong1 == lv_nv.SelectedItems[i].SubItems[0].Text) { t = LuongNVDAO.Instance.Update(data.IDChamCong1, tb_sc.Text); if (t) { LuongNV luong = new LuongNV(); lv_nv.Items.Clear(); loadNhanVien(); lb_sc.Text = tb_sc.Text; lb_l.Text = data.Luong1.ToString(); // lb_l.Text = lv_nv.SelectedItems[i].SubItems[5].Text ; MessageBox.Show("Sửa thành công"); } } } } }
public void Show() { Console.WriteLine("TenNV\tLuong T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12"); for (int i = 0; i < MangNV.Count; i++) { NhanVien nv = MangNV[i]; Console.Write("{0}\t\t", nv.TenNV); for (int j = i * 12; j < (i + 1) * 12; j++) { LuongNV lgNv = MangLuongNV[j]; Console.Write(String.Format("{0:#.##} ", lgNv.LuongNhVien)); } Console.WriteLine(); } Console.WriteLine("------------"); for (int m = 0; m < MangGiaDinhNV.Count; m++) { Console.WriteLine("Thong tin nguoi than : "); Console.WriteLine("MaNV\tTen\tQuanHe\tNamSinh"); GiaDinhNV NgThanNv = MangGiaDinhNV[m]; Console.WriteLine("{0}\t{1}\t{2}\t{3}", NgThanNv.MaNV, NgThanNv.TenNgThan, NgThanNv.QuHe, NgThanNv.NamSinh); } //foreach (LuongNV lg in MangLuongNV) //{ // Console.WriteLine("thang {0}, luong {1}",lg.Thang, lg.LuongNhVien); //} Console.ReadLine(); }
public Boolean UpdateLuongNV(string MaPB, string MaNV, string MaLuong, long LCB, long PhuCap, long Thuong, long KyLuat, int Thang, int Nam, int SoGioLamThem, int SoNgayCong) { DataProviderLuongNV dp = new DataProviderLuongNV(); LuongNV bh = new LuongNV(MaPB, MaNV, MaLuong, LCB, PhuCap, Thuong, KyLuat, Thang, Nam, SoGioLamThem, SoNgayCong, TinhLuong(LCB, PhuCap, Thuong, KyLuat, SoGioLamThem, SoNgayCong)); return(dp.SuaLuongNV(bh)); }
public List <LuongNV> GetLuongs() { List <LuongNV> luongs = new List <LuongNV>(); DataTable data = DataProvider.Instance.ExecuteQuery("TinhLuong"); foreach (DataRow item in data.Rows) { LuongNV luong = new LuongNV(item); luongs.Add(luong); } return(luongs); }
public ActionResult XuatBangLuong(int id) { Luong lg = data.Luongs.SingleOrDefault(n => n.MaLuong == id); NhanVien nv = data.NhanViens.SingleOrDefault(n => n.MaNV == lg.MaNV); QuyetDinhTD qd = data.QuyetDinhTDs.SingleOrDefault(n => n.MaQD == nv.MaQD); ChucVu cv = data.ChucVus.SingleOrDefault(n => n.MaCV == qd.MaCV); decimal mucLuong = 0; decimal giatringaycong = 0; decimal giatritresom = 0; decimal giatringaynghicop = 0; decimal giatringaynghikp = 0; decimal giatriphutroi = 0; if (nv.TinhTrang == "Thử việc") { mucLuong = cv.MucLuongThuViec; giatringaycong = Convert.ToDecimal(mucLuong * lg.Songaycong); giatritresom = Convert.ToDecimal(mucLuong * lg.Solantresom); giatringaynghicop = Convert.ToDecimal(mucLuong * lg.Songaynghicop); giatringaynghikp = Convert.ToDecimal(mucLuong * lg.Songaynghikp); giatriphutroi = Convert.ToDecimal(mucLuong * lg.Sogiopt); } else { mucLuong = cv.MucLuongCT; giatringaycong = Convert.ToDecimal(mucLuong * lg.Songaycong); giatritresom = Convert.ToDecimal(mucLuong * lg.Solantresom); giatringaynghicop = Convert.ToDecimal(mucLuong * lg.Songaynghicop); giatringaynghikp = Convert.ToDecimal(mucLuong * lg.Songaynghikp); giatriphutroi = Convert.ToDecimal(mucLuong * lg.Sogiopt); } LuongNV db = new LuongNV(); db.DataTable1.AddDataTable1Row(lg.MaLuong, lg.MaNV, nv.HoTen, lg.Thang, lg.Nam, Convert.ToInt32(lg.Songaycong), Convert.ToInt32(lg.Solantresom), Convert.ToInt32(lg.Songaynghicop), Convert.ToInt32(lg.Songaynghikp), Convert.ToDecimal(lg.Khenthuong), Convert.ToDecimal(lg.Kyluat), lg.GiaTri, mucLuong, Convert.ToInt32(lg.Sogiopt), giatringaycong, giatritresom, giatringaynghicop, giatringaynghikp, giatriphutroi); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Report/BangLuong.rpt"))); rd.SetDataSource(db); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "Bangluong.pdf")); }
public void ThemNV() { Console.Write("Nhap so Nhan vien can them : "); short SoNv = Convert.ToInt16(Console.ReadLine()); Console.WriteLine("----------------"); for (int i = 0; i < SoNv; i++) { Console.WriteLine("Nhap ID NhanVien :"); short MaNV = Convert.ToInt16(Console.ReadLine()); Console.WriteLine("Nhap Ten NhanVien :"); string TenNV = Convert.ToString(Console.ReadLine()); NhanVien Nvien = new NhanVien(MaNV, TenNV); MangNV.Add(Nvien); Console.WriteLine("----------------"); for (int j = 0; j < 12; j++) { int Thang = j + 1; double luong = (double)(i + j + 1) * 11; LuongNV Luongnvien = new LuongNV(MaNV, Thang, luong); MangLuongNV.Add(Luongnvien); } } }