private void btnTongLuong_Click(object sender, EventArgs e) { Luong temp = new Luong(txtMaNV.Text, txtLuong.Text, txtLuongThuong.Text, txtGhichu.Text, txtSNTC.Text, txtTongLuong.Text); ConnectDatabase.TongLuong_NV(temp); dgvLuong_CaNhan.DataSource = ConnectDatabase.GetAllLuong_NV(); }
public static void SuaLuong_PhongBan(Luong l, ChucVu cv, NhanVien nv) { //string sql = "UPDATE LUONG set Luong = @luong, LuongThuong=@luongthuong, GhiChu=@ghichu where MaNV=@manv"; //using (SqlCommand command = new SqlCommand(sql, conn)) //{ // command.Parameters.Add(new SqlParameter("@tencv", cv.Tencv)); // command.Parameters.Add(new SqlParameter("@macv", cv.Macv)); // command.ExecuteNonQuery(); // command.Cancel(); //} }
public static void TongLuong_NV(Luong luong) { string sql = "update LUONG set TongLuong = SoNgayTangCa * 50000 + LuongCB + LuongThuong where MaNV = @Manv"; using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.Add(new SqlParameter("@luongCB", luong.LuongNV1)); command.Parameters.Add(new SqlParameter("@luongthuong", luong.LuongThuong1)); command.Parameters.Add(new SqlParameter("@ghichu", luong.Chichu1)); command.Parameters.Add(new SqlParameter("@SNTC", luong.SoNgayTangCa1)); command.Parameters.Add(new SqlParameter("@TongLuong", luong.TongLuong1)); command.Parameters.Add(new SqlParameter("@manv", luong.MaNV1)); command.ExecuteNonQuery(); command.Cancel(); } }
public static void SuaLuong_PB(Luong luong) { string sql = "UPDATE LUONG set LuongCB=@luongCB, LuongThuong=@luongthuong, GhiChu=@ghichu, SoNgayTangCa = @SNTC, TongLuong = @TongLuong where MaNV=@manv"; using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.Add(new SqlParameter("@luongCB", luong.LuongNV1)); command.Parameters.Add(new SqlParameter("@luongthuong", luong.LuongThuong1)); command.Parameters.Add(new SqlParameter("@ghichu", luong.Chichu1)); command.Parameters.Add(new SqlParameter("@SNTC", luong.SoNgayTangCa1)); command.Parameters.Add(new SqlParameter("@TongLuong", luong.TongLuong1)); command.Parameters.Add(new SqlParameter("@manv", luong.MaNV1)); command.ExecuteNonQuery(); command.Cancel(); } }