public void Xoa(PhieuLuongEntity pl)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblPhieuLuong WHERE MaPhieuLuong=@MaPhieuLuong";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaPhieuLuong", pl.MaPhieuLuong);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
PhieuLuongEntity pl = new PhieuLuongEntity();
pl.MaPhieuLuong = MaLuong;
PhieuLuongBus plg = new PhieuLuongBus();
plg.Xoa(pl);
}
catch
{
MessageBox.Show("Mời bạn chọn phiếu lương cần xóa");
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
PhieuLuongEntity pl = new PhieuLuongEntity();
pl.MaPhieuLuong = maLG;
pl.LuongCoBan = txtLuongCoBan.Text;
pl.HeSoLuong = txthsl.Text;
pl.PhuCap = txtPhuCap.Text;
pl.TienThuong = txtTienThuong.Text;
pl.TongLinh = txtTongLinh.Text;
pl.NgayLinh = dtNgayLinh.Value.ToString();
PhieuLuongBus plg = new PhieuLuongBus();
plg.Sua(pl);
}
public void Sua(PhieuLuongEntity pl)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblPhieuLuong SET MaNV =@MaNV, LuongCoBan =@LuongCoBan, HeSoLuong =@HeSoLuong, TienThuong =@TienThuong, PhuCap =@PhuCap, TongLinh =@TongLinh, NgayLinh =@NgayLinh WHERE MaPhieuLuong=@MaPhieuLuong";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaNV", pl.MaNV);
cdm.Parameters.AddWithValue("@LuongCoBan", pl.LuongCoBan);
cdm.Parameters.AddWithValue("@HeSoLuong", pl.HeSoLuong);
cdm.Parameters.AddWithValue("@TienThuong", pl.TienThuong);
cdm.Parameters.AddWithValue("@PhuCap", pl.PhuCap);
cdm.Parameters.AddWithValue("@TongLinh", pl.TongLinh);
cdm.Parameters.AddWithValue("@NgayLinh", pl.NgayLinh);
cdm.Parameters.AddWithValue("@MaPhieuLuong", pl.MaPhieuLuong);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(PhieuLuongEntity pl)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblPhieuLuong(MaPhieuLuong, MaNV, LuongCoBan, HeSoLuong, TienThuong, PhuCap, TongLinh, NgayLinh) VALUES(@MaPhieuLuong,@MaNV,@LuongCoBan,@HeSoLuong,@TienThuong,@PhuCap,@TongLinh,@NgayLinh)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaPhieuLuong", pl.MaPhieuLuong);
cdm.Parameters.AddWithValue("@MaNV", pl.MaNV);
cdm.Parameters.AddWithValue("@LuongCoBan", pl.LuongCoBan);
cdm.Parameters.AddWithValue("@HeSoLuong", pl.HeSoLuong);
cdm.Parameters.AddWithValue("@TienThuong", pl.TienThuong);
cdm.Parameters.AddWithValue("@PhuCap", pl.PhuCap);
cdm.Parameters.AddWithValue("@TongLinh", pl.TongLinh);
cdm.Parameters.AddWithValue("@NgayLinh", pl.NgayLinh);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
